LOWER Function [String]

Converts all characters in a string to lowercase.

Syntax

LOWER ( string-expression )

Parameters

Parameters
Parameter	Description
string-expression	The string to be converted.

Returns

CHAR

NCHAR

LONG VARCHAR

VARCHAR

NVARCHAR

Note: The result data type is a LONG VARCHAR. If you use LOWER in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set LOWER to the correct data type and size.

Example

The following statement returns the value “lower case”:

SELECT LOWER( 'LOWER CasE' ) FROM iq_dummy

Standards and Compatibility

SQL—ISO/ANSI SQL compliant.
Sybase—Compatible with Adaptive Server Enterprise.