LOWER function [String]

Function

Converts all characters in a string to lowercase.

Syntax

LOWER ( string-expression )

Parameters

string-expression The string to be converted.

NoteThe result datatype 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 datatype and size.

See “REPLACE function [String]” for more information.

Example

The following statement returns the value “lower case”:

SELECT LOWER( 'LOWER CasE' ) FROM iq_dummy

Standards and compatibility

See also

“LCASE function [String]”

“UCASE function [String]”

“UPPER function [String]”