LCASE Function [String]

Converts all characters in a string to lowercase.

Syntax

LCASE ( string-expression )

Parameters

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.

Example

The following statement returns the value “lower case”:

SELECT LCASE( 'LOWER CasE' ) FROM iq_dummy

Standards and Compatibility

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—LCASE is not supported in Adaptive Server Enterprise; you can use LOWER to get the same functionality.