Skip to main content
Version: 0.0.1

INITCAP

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

{{< codeheader "INITCAP example" >}}

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

{{< codeheader "INITCAP example" >}}

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