The function returns a random number between 0 and 1. This can be used to create sample data.
rand(
)
Example:
This example script creates a table of 1000 records with randomly selected upper case characters, that is, ASCII characters in the range 65 to 91 (65+26).
Load
Chr( Floor(rand() * 26) + 65) as UCaseChar,
RecNo() as ID
Autogenerate 1000;