Difference between revisions of "MAX()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return maximum value function
 
Function to return maximum value function
Line 28: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data Functions]]
 
[[Category:Numeric Data Functions]]

Latest revision as of 16:45, 3 December 2009

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 Server, Recital