|Built-in Functions / Standard Built-in Functions|
UCASE or UPPER takes a character expression as a parameter and returns a string in which all alpha characters have been converted to uppercase.
UCASE or UPPER ( CharacterExpression )
If the parameter type is CHAR , the return type is CHAR. Otherwise, the return type is VARCHAR.
The length and maximum length of the returned value are the same as the length and maximum length of the parameter.
VALUES UPPER('aSD1#w')The value returned is ASD1#W.