Skip to main content
Version: 24.3.x

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