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

LCASE function [String]

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

LCASE( string-expression )

string-expression    The string to be converted to lowercase.

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

The LCASE function is similar to the LOWER function.

• SQL/2003    Vendor extension.

The following statement returns the value chocolate.

SELECT LCASE( 'ChoCOlatE' );