UPPER function [String]

Function

Converts all characters in a string to uppercase.

Syntax

UPPER ( string-expression )

Parameters

string-expression The string to be converted to uppercase.

See “REPLACE function [String]” for more information.

Example

The following statement returns the value “CHOCOLATE”:

SELECT UPPER( 'ChocoLate' ) FROM iq_dummy

Usage

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.

Standards and compatibility

See also

“LCASE function [String]”

“LOWER function [String]”

“UCASE function [String]”