initcap function (Databricks SQL)

Returns expr with the first letter of each word in uppercase.

Syntax

initcap(expr)

Arguments

  • expr: A STRING expression.

Returns

A STRING.

All other letters are in lowercase. Words are delimited by white space.

Examples

> SELECT initcap('sPark sql');
 Spark Sql