In This Topic

RAND

In This Topic

This function returns an evenly distributed random number between 0 and 1.

RAND()

This function does not accept arguments.

This function returns a new random number.

To generate a random real number between *x* and *y*, with *y* greater than *x*, use the following expression:

RAND()*(y-x)+x

To generate a random integer between x and y, with y greater than x, use the following expression:

INT((y-x+1)*RAND()+x)

For more information, refer to Volatile Functions.

Does not accept data. Returns numeric data.

RAND()

RAND()*100

INT(RAND()*100)

See Also