Progress
SQL-92
Guide and Reference


RAND Function

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

SYNTAX

RAND ( [ expression ] ) 

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 SYSPROGRESS.SYSCALCTABLE; 

NOTE

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095