Progress
SQL-92
Guide and Reference


UCASE Function

Returns the result of the argument character expression after converting all the characters to uppercase. UCASE is identical to UPPER, but provides ODBC-compatible syntax.

SYNTAX

UCASE ( char_expression ) 

EXAMPLE

The example illustrates the UCASE function, returning columns from rows in the customer table where the last_name column, after being converted to uppercase, is equal to ’SMITH’:

SELECT *
    FROM customer
    WHERE UCASE (last_name) = ’SMITH’ ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095