Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (E-O)

 

LESSER function [Miscellaneous]

Returns the lesser of two parameter values.

Syntax
LESSER( expression-1, expression-2 )
Parameters
  • expression-1   The first parameter value to be compared.

  • expression-2   The second parameter value to be compared.

Returns

The return type for this function depends on the expressions specified. That is, when the database server evaluates the function, it first searches for a data type in which all the expressions can be compared. When found, the database server compares the expressions and then returns the result in the type used for the comparison. If the database server cannot find a common comparison type, an error is returned.

Remarks

If the parameters are equal, the first value is returned.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value 5.

SELECT LESSER( 10, 5 ) FROM dummy;