UPPER()

UPPER() converts all alphabetic characters of an expression or field value to upper case.

Use UPPER() when you search for data in mixed or unknown case.

Function Format

UPPER(C)

The UPPER() function converts all alphabetic characters in C to upper case. All non-alphabetic characters are left unchanged.

See also PROPER(), which converts alphabetic characters to upper case and lower case; and LOWER(), which converts alphabetic characters to lower case.

Examples

UPPER("ABC") = "ABC"

UPPER("abc 123 DEF") = "ABC 123 DEF"

UPPER("AbCd 12") = "ABCD 12"

If capitalization is a concern, you can identify all customers named “Smith” by specifying the condition:

UPPER(NAME) = "SMITH"