LOWER( string-expression )

CHAR, VARCHAR, or LONG VARCHAR corresponding to the data type of the argument.

The LCASE function is identical to the LOWER function.

• LCASE function [String]
• UCASE function [String]
• UPPER function [String]
• UltraLite string functions

The following statement returns the value chocolate.

SELECT LOWER( 'chOCOLate' );