ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

LESSER function [Miscellaneous]

Function 

Returns the lesser of two parameter values. If the parameters are equal, the first is returned.

Syntax 

LESSER ( expression1, expression2 )

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

GREATER function [Miscellaneous]

Example 

The following statement returns the value 5.

SELECT LESSER( 10,5 ) FROM dummy