Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## UCASE

> 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

> - 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`.

> - A `char_expression` and the result can contain multi-byte characters. The uppercase conversion is determined by the case table in the `convmap` file. The default case table is `BASIC`.

> ##### Compatibility

> ODBC compatible

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