Function: Rand
Description
Generates a pseudo-random number in the range 0 to 32767.
Syntax
Rand()
Arguments
None.
Return value
This function returns a number in the range 0 to 32767.
Calculated field example
To generate a field filled with random numbers, use the following calculated field expression: Rand()
This application of the Rand() function has application in certain areas, such as auditing (see Filter example, below).
Filter/Find example
Certain tasks, such as auditing, require that you generate a random subset of the table database. This can be done in Monarch Classic using the Rand() function. A random group of records can be selected using the filter expression: Rand()>=300.And.Rand()<=350
You may use any numeric range in the set of numbers from 0 - 32767 to select a random group of records. You should be aware, however, that with this use of the Rand() function, the number of records returned is variable. If none of the randomly generated numbers happen to fall within the range you specify, Monarch Classic will return a blank table database.
© 2024 Altair Engineering Inc. All Rights Reserved.