Progress
SQL-92
Guide and Reference
INITCAP Function
Returns the result of the argument character expression after converting the first character to uppercase and the subsequent characters to lowercase.
SYNTAX
EXAMPLE
The following example shows how to use the INITCAP function:
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 may 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 theconvmap
file. The default case table is BASIC.COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |