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

Affects only alphabetic characters
Non-alphabetic characters remain unchanged
Handles Unicode characters correctly

Examples

FeatureQL

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

Result

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

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes Examples