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.

Example

The following statement returns the value CHOCOLATE.

SELECT UCASE( 'ChocoLate' ) FROM iq_dummy

Standards and compatibility

SQL/92 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]”