On this page

    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