lcase function

Applies to: Databricks SQL 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

> SELECT lcase('LowerCase');
 lowercase

Related functions

• lower function

• initcap function

• ucase function

• upper function