INITCAP

The INITCAP function converts the first letter of each word in a string to uppercase, and converts any remaining characters in each word to lowercase. Words are delimited by white space characters, or by characters that are not alphanumeric.

Syntax

INITCAP( charExpression );

charExpression

The string to be converted. This can be a CHAR or VARCHAR data type, or another type that gets implicitly converted.

Results

The returned string has the same data type as the input charExpression.

Examples

splice> VALUES( INITCAP('this is a test') );
1
---------------------------------------------------------------------
This Is A Test
1 row selected

splice> VALUES( INITCAP('tHIS iS a test') );
1
---------------------------------------------------------------------
This Is A Test
1 row selected

See Also