MAX()
From Recital Documentation Wiki
Revision as of 11:48, 23 March 2009 by Yvonnemilne (Talk | contribs)
Class
Numeric Data
Purpose
Function to return maximum value function
Syntax
MAX(<exp1>,<exp2>)
See Also
AMAX(), AMIN(), IIF(), MIN(), MOD()
Description
The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.
Example
? max(1, 3) 3 set date british ? max(ctod("15/10/1997"), ctod("14/10/1997")) 15/10/1997
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer