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.
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:
Syntax alternatives: UCASE is a synonym for UPPER.
SELECT UPPER('abcdef') FROM SYSIBM.SYSDUMMY1Returns the value 'ABCDEF'.
SELECT UPPER(
)
FROM SYSIBM.SYSDUMMY1
Returns the value:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.