4.9.2.95 UCASE function (ODBC compatible)

Syntax

UCASE ( char_expression )

Description

The scalar function UCASE returns the result of the argument character expression after converting all the characters to upper case. UCASE is identical to UPPER, but provides ODBC-compatible syntax.

Example

SELECT *
     FROM  customer
     WHERE UCASE (name) = 'SMITH' ;

Notes

• The argument to the function must be of type CHARACTER.
• The result is of type CHARACTER.
• If the argument expression evaluates to null, the result is null.