`lower` function

Applies to: check marked yes Databricks SQL Databricks Runtime

Returns expr with all characters changed to lowercase.

Syntax

lower(expr)

Arguments

expr: A STRING expression.

Returns

A STRING.

Examples

> SELECT lower('LowerCase');
 lowercase