ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

UCASE function [String]

Function 

Converts all characters in a string to upper case.

Syntax 

UCASE ( string-expression )

Parameters 

string-expression    The string to be converted to upper case.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    UCASE is not supported by Adaptive Server Enterprise, but UPPER provides the same feature in a compatible manner.

See also 

UPPER function [String]

LCASE function [String]

Example 

The following statement returns the value CHOCOLATE.

SELECT UCASE( 'ChocoLate' )