Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

UPPER function [String]

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

UPPER( string-expression )

string-expression    The string to be converted to uppercase.

The UCASE function is similar to the UPPER function.

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

• SQL/2003    Vendor extension.

The following statement returns the value CHOCOLATE.

SELECT UPPER( 'ChocoLate' );