ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

GREATER function [Miscellaneous]

Function 

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

Syntax 

GREATER ( expression1, expression2 )

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

LESSER function [Miscellaneous]

Example 

The following statement returns the value 10.

SELECT GREATER( 10,5 ) FROM dummy