INITCAP

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.