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

Syntax

UCASE( string-expression )

Parameters

Returns

VARCHAR

NVARCHAR

LONG VARCHAR

LONG NVARCHAR

See also

• UPPER function [String]
• LCASE function [String]
• String functions

Standards and compatibility

Example

The following statement returns the value CHOCOLATE.

SELECT UCASE( 'ChocoLate' );