ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

RAND function [Numeric]

Function 

Returns a random number in the interval 0 to 1, with an optional seed.

Syntax 

RAND ( [integer-expression] )

Parameters 

integer expression    The optional seed used to create a random number. This argument allows you to create repeatable random number sequences.

Usage 

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns a value of approximately 0.0554504.

SELECT RAND( 4 )