Converts all characters in a string to uppercase.
UPPER( 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 UCASE function.
SQL/2008 The UPPER function is a core feature of the SQL/2008 standard.
The following statement returns the value CHOCOLATE.
SELECT UPPER( 'ChocoLate' );