![LOG10 function [Numeric]](arrow-left.gif){kind=icon}
![LTRIM function [String]](arrow-right.gif){kind=icon}
Converts all characters in a string to lowercase.
LOWER ( string-expression )
string-expression The string to be converted.
The
result data type of a LOWER function is a LONG
VARCHAR. If you use LOWER in a SELECT
INTO statement, you must have a Large Objects Management
option license or use CAST and set LOWER to
the correct data type and size.
See “REPLACE function [String]” for more information.
The following statement returns the value “lower case”:
SELECT LOWER( 'LOWER CasE' ) FROM iq_dummy
