Min

Description

Determines the smaller of two numbers.

Syntax

Min ( x, y )

Argument

Description

x

The number to which you want to compare y

y

The number to which you want to compare x

Returns

The datatype of x or y, whichever datatype is more precise. If any argument’s value is null, Min returns null.

Usage

If either of the values being compared is null, Min returns null.

Examples

Example 1

This statement returns 4:

Min(4,7)

Example 2

This statement returns -7:

Min(- 4, - 7)

Example 3

This statement returns 3.0, a decimal value:

Min(9.2,3.0)

See also