LEAST: Returning the Smallest Value

How to:

With two or more arguments, LEAST returns the smallest (minimum-valued) argument. The arguments are compared using the following rules:

If any argument is NULL, the result is NULL. No comparison is needed.
If the return value is used in an INTEGER context, or all arguments are integer-valued, they are compared as integers.
If the return value is used in a floating-point context, or all arguments are floating-point-valued, they are compared as floating-point values.
If the arguments comprise a mix of numbers and strings, they are compared as numbers.
If any argument is a character string, the arguments are compared as character strings. In all other cases, the arguments are compared as binary strings.

Syntax: How to Return the Smallest Value

LEAST(value1, value2, ... , valuen)

where:

value1, value2, ... , valuen

Numeric or alphanumeric

Are the values to be compared.

LEAST returns the smallest argument.

LEAST(X,Y,Z)

For X=2, Y=0, and Z=-1, the result is -1.

For X='B', Y='A', and Z='C', the result is 'A'.

	WebFOCUS