lcase.md

description
Returns the input expression with all the characters converted to lowercase.

LCASE

Syntax

LCASE(expression varchar) → varchar

• expression: String to convert to lowercase.

Examples

{% code title="LCASE example" %}

SELECT LCASE('A GUIDE to data Lakehouses')
-- a guide to data lakehouses

{% endcode %}

{% code title="LCASE example" %}

SELECT Category, LCASE(Category) 
  FROM eth.recent_blocks 
  LIMIT 3

-- Category, EXPR$1
-- WEAPON LAWS, weapon laws
-- WEAPON LAWS, weapon laws
-- WARRANTS, warrants

{% endcode %}

Usage Notes

LCASE is a synonym for LOWER.