Progress
SQL-92
Guide and Reference


UPPER Function

Returns the result of the argument character expression after converting all the characters to uppercase.

SYNTAX

UPPER ( char_expression ) 

EXAMPLE

The example illustrates the UPPER 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 UPPER (last_name) = ’SMITH’ ; 

NOTES

COMPATIBILITY

SQL-92 Compatible


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