Description
The LOWER function converts all characters in a text field to lowercase.
Usage
LOWER(text)
| Argument | Type | Required | Description |
|---|---|---|---|
| text | Text | Yes | The input text to convert to lowercase |
Remarks
If the text argument is blank, the result is blank.
The conversion follows Unicode case-folding rules and works correctly for accented characters and letters from non-Latin scripts (for example, LOWER("Ä") returns "ä").
Examples
When data is collected from multiple sources, the same value may appear in different cases — for example, "Yes", "YES", and "yes". You can normalize these before comparing:
LOWER(CONSENT) == "yes"
If a form contains a COUNTRY_CODE field that users may have entered in mixed case, you can standardize it:
LOWER(COUNTRY_CODE)
| COUNTRY_CODE | Result |
|---|---|
| UGA | uga |
| Uga | uga |
| uga | uga |