![UCASE function [String]](arrow-left.gif){kind=icon}
![USER_ID function [System]](arrow-right.gif){kind=icon}
Converts all characters in a string to uppercase.
UPPER ( string-expression )
string-expression The string to be converted to uppercase.
See “REPLACE function [String]” for more information.
The following statement returns the value “CHOCOLATE”:
SELECT UPPER( 'ChocoLate' ) FROM iq_dummy
The result datatype of an UPPER function is a LONG VARCHAR. If you use UPPER in a SELECT INTO statement, you must have a Large Objects Management option license or use CAST and set UPPER to the correct datatype and size.
