Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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