Converts all characters in a string to uppercase.
UCASE( string-expression )
string-expression The string to be converted to uppercase.
CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, or LONG NVARCHAR 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' );