Menu
Amazon Kinesis Data Analytics
SQL Reference

INITCAP

INITCAP ( <character-expression> )

Returns a converted version of the input string such that the first character of each space-delimited word is upper-cased, and all other characters are lower-cased.

Examples

Function Result

INITCAP('each first letter is cAPITALIZED')

Each first letter is capitalized

INITCAP('')

<empty string>

INITCAP(cast(null as varchar(3)))

<null>

Note

The INITCAP function is not part of the SQL:2008 standard. It is an Amazon Kinesis Data Analytics extension.

On this page: