LOWER

Turns all uppercase (capital) letters into lowercase letters

Usage

LOWER(text)

Parameters

text

(Required) The text to transform

Examples

Example With these variables Result

LOWER(“John Doe”)

(None)

“john doe”

LOWER(country)

country is "CANADA"

“canada”

More information

If you use a variable, its value will not be modified. So the LOWER function will return the transformed text, but if you use the variable elsewhere, it will have its original text.

See also