UPPER

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-UPPER--(--expression--)-------------------------------------><
 

The UPPER function returns a string in which all the characters have been converted to uppercase characters, based on the CCSID of the argument. Only SBCS and Unicode graphic characters are converted. The characters a-z are converted to A-Z, and characters with diacritical marks are converted to their uppercase equivalent, if any. Refer to the UCS-2 level 1 mapping tables section of the Globalization topic in the iSeries Information Center for a description of the monocasing tables that are used for this translation.

expression
An expression that specifies the string to be converted. expression must be any built-in numeric, character, Unicode graphic string. A numeric argument is cast to a character string before evaluating the function. For more information on converting numeric to a character string, see VARCHAR.

The result of the function has the same data type, length attribute, actual length, and CCSID as the argument. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

When UPPER is specified in a query, the query cannot contain:

Note

Syntax alternatives: UCASE is a synonym for UPPER.

Examples