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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL function reference » Alphabetical list of functions


LESSER function [Miscellaneous]

Returns the lesser of two parameter values.

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

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


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

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


The following statement returns the value 5.

SELECT LESSER( 10, 5 ) FROM dummy;