LOWER function

Converts all uppercase characters to lowercase characters in a given string.

Syntax

LOWER ( string )

Arguments

string

The field name or expression of data type string that the function converts.

Return type

string

Examples

SELECT LOWER('AbCdEfG!@#$') FROM << 0 >> -- 'abcdefg!@#$'

Related functions

• CHAR_LENGTH

• SUBSTRING

• TRIM

• UPPER