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.