The UPPER function returns the text string that it receives as an argument after converting all its letters to their uppercase equivalents.
Syntax
UPPER(
text
)
Parameters
- text: Text string or name of the column containing the texts to be converted to uppercase.
Returned value
The UPPER function returns a text string.
Additional Information
Characters that are not letters are not modified:
In this example you can see how accented vowels are converted, as well as "ñ" and "ç". Numbers and special characters are not.
Examples
In the following example we want to use as product code its name converted to uppercase letters, for which the UPPER function is used:
Related functions
Category
Text