The RANDOM() function (also abbreviated as RAND() or RND()) returns a random number between zero and the value of a specified numeric expression or field value.
Use RANDOM() when you need to generate a random number for use inside or outside of Analyzer.
RANDOM(N) or RAND(N) or RND(N)
RANDOM() returns a random number greater than or equal to 0 and less than the numeric expression or field value N. The random number generated has the same number of decimals as N.
Note: If you use RANDOM() twice consecutively with the same value, it produces different results. The sequence is not reseeded before Analyzer generates the second result. To reseed the sequence, use the RANDOM command.
RAND(1000.00) = 278.61
RND(10000) = 3781