SQL-J Language Reference
Page 86 of 121

UPPER

UPPER takes a character expression as a parameter and returns a string in which all alpha characters have been converted to uppercase.

Syntax

UPPER ( CharacterExpression )

A characterExpression is a CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, OR LONG NVARCHAR data type, any built-in type that is implicitly converted to a string, or any Java data type that directly maps to a built-in type that is implicitly converted to a string.

If the parameter type is CHAR or LONG VARCHAR, the return type is CHAR or LONG VARCHAR. Otherwise, the return type is VARCHAR. If the parameter type is NCHAR, NVARCHAR, or LONG NVARCHAR, the return type is NCHAR, NVARCHAR, or LONG NVARCHAR.

NOTE: UPPER and LOWER follow the database locale. See locale=ll_CC for more information about specifying locale.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.

UPPER Example

-- returns 'ASD1#W'
UPPER('aSD1#w')