Categories: String, Binary

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

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