Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## INITCAP

> Returns the result of the argument character expression after converting the first character to uppercase and the subsequent characters to lowercase.

> #### Syntax

>     INITCAP ( char_expression )

> Example

> The following example shows how to use the `INITCAP` function:

>     SELECT INITCAP (last_name)
>          FROM customer ;

> #### Notes

> - The `char_expression` 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 for the first character and the lowercase conversion for the rest of the characters is based on the case table in the `convmap` file. The default case table is `BASIC`.

> ##### Compatibility

> Progress extension

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