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();