lcase function

Applies to: Databricks SQL Databricks Runtime

Returns expr with all characters changed to lowercase according to the collation of expr.

lcase(expr)

• expr: A STRING expression.

A STRING.

> SELECT lcase('LowerCase');
 lowercase

• lower function
• initcap function
• ucase function
• upper function