Converts all characters in a string to uppercase.
Syntax
UCASE ( string-expression )
Parameters
Parameter
|
Description
|
|---|
string-expression
|
The string to be converted to uppercase.
|
Returns
VARCHAR
NVARCHAR
LONG VARCHAR
LONG NVARCHAR
Note: The
result data type is a LONG
VARCHAR. If you use UCASE in a SELECT
INTO statement, you must have an Unstructured Data Analytics
Option license, or use CAST and set UCASE to
the correct data type and size.
Example
The following statement returns the value “CHOCOLATE”:
SELECT UCASE( 'ChocoLate' ) FROM iq_dummy
Standards and Compatibility
SQL—Vendor
extension to ISO/ANSI SQL grammar.
Sybase—UCASE is not
supported by Adaptive Server Enterprise, but UPPER provides
the same feature in a compatible manner