initcap.md

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

INITCAP

Syntax

INITCAP(expression varchar) → varchar

• expression: Input string.

Examples

{% code title="INITCAP example" %}

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

{% endcode %}

{% code title="INITCAP example" %}

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

{% endcode %}