initcap function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr with the first letter of each word in uppercase according to the collation of expr. All other letters are in lowercase. Words are delimited by white space.

Syntax 

initcap(expr)

Arguments

  • expr: A STRING expression.

Returns

A STRING.

Examples 

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