Converts all characters in a string to uppercase. This function is identical the UCASE function.

Syntax

UPPER( string-expression )

Parameters

Returns

VARCHAR

NVARCHAR

LONG VARCHAR

LONG NVARCHAR

Remarks

The UCASE function is similar to the UPPER function.

See also

• UCASE function [String]
• LCASE function [String]
• LOWER function [String]
• String functions

Standards and compatibility

Example

The following statement returns the value CHOCOLATE.

SELECT UPPER( 'ChocoLate' );