INITCAP

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Scalar Functions >

INITCAP

Previous pageReturn to chapter overviewNext page

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('i love STREAMing SQL')

I Love Streaming Sql

INITCAP('')

<empty string>

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

<null>

Notes

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