Converts all characters in a string to uppercase.
UCASE( string-expression )
string-expression The string to be converted to uppercase.
CHAR, VARCHAR, or LONG VARCHAR corresponding to the data type of the argument.
This function is identical to the UPPER function.
SQL/2008 Vendor extension. The UPPER function is SQL/2008 compliant.
The following statement returns the value CHOCOLATE.
SELECT UCASE( 'ChocoLate' );