LOWER()

LOWER() converts all alphabetic characters of an expression or field to lower case. The LOWER() function is the inverse of the UPPER() function.

Use LOWER() when you search for data that is in mixed or unknown case or when you want data in lower case for formatting.

Function Format

LOWER(C)

The LOWER() function converts all alphabetic characters in a string C to lower case. All non-alphabetic characters are left unchanged. For more information, see PROPER(), which converts alphabetic characters to proper case; and UPPER(), which converts alphabetic characters to upper case.

Examples

LOWER("ABC") = "abc"

LOWER("abc 123 DEF") = "abc 123 def"

LOWER("AbCd 12") = "abcd 12"

To create a Name field in lower case, specify:

LOWER(Name)