INITCAP

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.

Syntax

INITCAP ( <character-expression> )

Examples

Function Result
INITCAP(‘i love STREAMing SQL’) I Love Streaming Sql
INITCAP('')
INITCAP(cast(null as varchar(3)))

Notes

The INITCAP function is not part of the SQL standard. It is a SQLstream extension.