Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Converts all characters in a string to lowercase.
LCASE( string-expression )
The string to be converted to lowercase.
The LCASE function is identical to the LOWER function.
Vendor extension. The equivalent function LOWER is a core feature of the SQL/2008 standard.
The following statement returns the value chocolate.
SELECT LCASE( 'ChoCOlatE' );