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

LOWER function [String]

Converts all characters in a string to lowercase. This function is identical the LCASE function.

LOWER( string-expression )

string-expression    The string to be converted.

The LCASE function is identical to the LOWER function.

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

• SQL/2003    Core feature.

The following statement returns the value chocolate.

SELECT LOWER( 'chOCOLate' );