MinValue

MinValue compares two input values and returns the smallest one.

Syntax

MinValue(<value1>,<value_2>)

Return Type

Varies. Depends on data type of input values.

Details

String comparisons use natural sort order. Be aware when mixing input value data types.

Examples

select MinValue('aardvark', 'Aardvark')
from Empty();

select MinValue('200','22')
from Empty();

select MinValue(200,22)
from Empty();

Related Functions

Compare

MaxValue