UPPER( ) function

Returns a string with alphabetic characters converted to uppercase.

Syntax

UPPER(string)

Parameters

Name	Type	Description
string	character	The value to convert to uppercase.

Output

Character.

Examples

Basic examples

Returns "ABC":

UPPER("abc")

Returns "ABC 123 DEF":

UPPER("abc 123 DEF")

Returns "ABCD 12":

UPPER("AbCd 12")

Returns all the values in the Last_Name field converted to uppercase:

UPPER(Last_Name)

Remarks

How it works

The UPPER( ) function converts all alphabetic characters in string to uppercase. All non-alphabetic characters are left unchanged.

When to use UPPER( )

Use UPPER( ) when you need to ensure that all characters in a field, variable, or expression have consistent casing. Consistent casing is particularly important when you are comparing values.

UPPER( ) can also be used for formatting values in reports as uppercase text.