lcase function

December 12, 2024

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

lcase(expr)

Arguments

  • expr: A STRING expression.

Returns

A STRING.

Examples

SQL
> SELECT lcase('LowerCase');
 lowercase