Skip to main content

lower function

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

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

Syntax​

lower(expr)

Arguments​

  • expr: A STRING expression.

Returns​

A STRING.

Examples​

SQL
> SELECT lower('LowerCase');
lowercase