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
: ASTRING
expression.
Returns
A STRING
.
Examples
> SELECT initcap('sPark sql');
Spark Sql