Converts all characters in a string to lowercase.
Syntax
LCASE ( string-expression )
Parameters
Parameter
|
Description
|
string-expression
|
The string to be converted to lowercase.
|
Returns
CHAR
NCHAR
LONG VARCHAR
VARCHAR
NVARCHAR
Note: The
result data type is a LONG
VARCHAR. If you use LCASE in a SELECT
INTO statement, you must have an Unstructured Data Analytics
Option license or use CAST and set LCASE to
the correct data type and size.
Standards and Compatibility
Example
The following statement returns the value “lower case”:
SELECT LCASE( 'LOWER CasE' ) FROM iq_dummy