Converts all characters in a string to lowercase.
LCASE( string-expression )
string-expression The string to be converted to lowercase.
The LCASE function is identical to the LOWER function.
SQL/2008 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' );