LOWER()

Returns the string with all characters converted to lowercase.

Signatures

Returns: String with all characters converted to lowercase

LOWER(string: VARCHAR) → VARCHAR

sql

Parameter	Type	Required	Description
`string`	`VARCHAR`	Yes	Input string to convert

Notes

Letters become lowercase; digits, punctuation, and most symbols stay unchanged
LOWER('') is ''; if the input is NULL the result is NULL (use NULL(VARCHAR); bare NULL fails inference)

Examples

FeatureQL

SELECT
    -- All uppercase to lowercase
    f1 := LOWER('HELLO WORLD'),
    -- Mixed case to lowercase
    f2 := LOWER('Mixed Case String'),
    -- Letters and numbers
    f3 := LOWER('ABC123XYZ'),
    -- Unicode characters
    f4 := LOWER('CAFÉ'),
    -- Numbers and symbols unchanged
    f5 := LOWER('123!@#'),
    -- NULL yields NULL
    f6 := LOWER(NULL(VARCHAR))
;

Result

f1 VARCHAR	f2 VARCHAR	f3 VARCHAR	f4 VARCHAR	f5 VARCHAR	f6 VARCHAR
hello world	mixed case string	abc123xyz	café	123!@#	NULL

Suggest changes to this page

Last update at: 2026/06/20 10:08:10

On this page

Signatures Notes Examples