UCASE or UPPER function

The UCASE or UPPER function takes a character expression as a parameter and returns a string in which all alphabetical characters have been converted to uppercase.


UCASE ( characterExpression )
UPPER ( characterExpression )
If the parameter type is CHAR, the return type is CHAR. Otherwise, the return type is VARCHAR.
Note: UPPER and LOWER follow the database locale. See territory=ll_CC attribute for more information about specifying locale.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.


To return the string aSD1#w in uppercase, use the following clause:
The value returned is ASD1#W.