MAX( ) Function

Example   See Also

Evaluates a set of expressions and returns the expression with the maximum value.

Syntax

MAX(eExpression1, eExpression2 [, eExpression3 ...])

Returns

Character, Numeric, Currency, Double, Float, Date, or DateTime

Arguments

eExpression1, eExpression2 [, eExpression3 ...]

Specify the expressions from which you want MAX( ) to return the expression with the highest value. All the expressions must be of the same data type.