![]() Previous |
![]() Next |
INITCAP
returns a specified text expression, with the first letter of each word in uppercase and all other letters in lowercase. Words are delimited by white space or non-alphanumeric characters. The data type of the return value is the same as the original text.
Return Value
CHAR | NCHAR | VARCHAR2 | NVARCHAR2
Syntax
INITCAP(char)
Arguments
char
can be any text expression.
Example
INITCAP('top ten tunes')
and INITCAP('TOP TEN TUNES')
both return the string Top Ten Tunes
.