LOWER()

All functions > STRING > LOWER()

Returns the string with all characters converted to lowercase.

Signatures

Returns: String with all characters converted to lowercase

LOWER(string: VARCHAR) → VARCHAR
sql
ParameterTypeRequiredDescription
stringVARCHARYesInput 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
    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
    f6 := LOWER(NULL(VARCHAR)) -- NULL yields NULL
;
Result
f1 VARCHARf2 VARCHARf3 VARCHARf4 VARCHARf5 VARCHARf6 VARCHAR
hello worldmixed case stringabc123xyzcafé123!@#NULL

Suggest changes to this page
Last update at: 2026/05/26 17:22:09