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.

Standards and Compatibility

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

Example

The following statement returns the value “lower case”:

SELECT LOWER( 'LOWER CasE' ) FROM iq_dummy