UPPER( string-expression )

CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, or LONG NVARCHAR corresponding to the data type of the argument.

This function is identical to the UCASE function.

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

The following statement returns the value CHOCOLATE.

SELECT UPPER( 'ChocoLate' );