Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : RAND
 

RAND

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