Returns a randomly generated number, using expression as an optional seed value.

Syntax

RAND ( [expression] )

Note

expression must be an INT (32-bit) data type.

Example

This example illustrates the RAND function, supplying an optional seed value of ‘3':

SELECT RAND(3) 'Random number using 3 as seed value'
     FROM MYMATH;

Compatibility

ODBC compatible