Categories: String

INITCAP

Returns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).

Syntax

INITCAP(expression varchar) → varchar

• expression: Input string.

Examples

INITCAP example

SELECT INITCAP('a guide to data lakehouses')
-- A Guide To Data Lakehouses

INITCAP example

SELECT INITCAP('a guide to data lakeHouses')
-- A Guide To Data Lakehouses