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

INITCAP ( char_expression ) 

EXAMPLE

The following example shows how to use the INITCAP function:

SELECT INITCAP (last_name) 
     FROM customer ; 

NOTES

COMPATIBILITY

Progress Extension


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