ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns a random number in the interval 0 to 1, with an optional seed.
RAND ( [integer-expression] )
integer expression The optional seed used to create a random number. This argument allows you to create repeatable random number sequences.
RAND is a non-deterministic function. Successive calls to RAND may return different values. The query optimizer does not cache the results of the RAND function.
For more information about non-deterministic functions, see Function caching.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
The following statement returns a value of approximately 0.0554504.
SELECT RAND( 4 )