Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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: ASTRINGexpression.
Returns
A STRING.
Examples
> SELECT lcase('LowerCase');
lowercase