initcap function

Applies to: Databricks SQL 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

Related functions

• lower function
• lcase function
• ucase function
• upper function