Skip to main content

UPPER

Converts all the letters in a string to upper case.

Syntax

UPPER(string value)

Example

If we take the example that a form allows the "Country" to be entered in any format (lower case, proper or upper). However we wish to store country as all upper case letters.

If we imagine that the Country column contains the following data: canada, United Kingdom, INDIA and GerManY then we can use the following expression:

UPPER(Country)

Which will return "CANADA", "UNITED KINGDOM", "INDIA", "GERMANY" in their respective rows.