LCASE
Returns the input expression with all the characters converted to lowercase.
Syntax
LCASE(expression varchar) → varchar
expression: String to convert to lowercase.
Examples
SELECT LCASE('A GUIDE to data Lakehouses')
-- a guide to data lakehouses
SELECT Category, LCASE(Category)
FROM eth.recent_blocks
LIMIT 3
-- Category, EXPR$1
-- WEAPON LAWS, weapon laws
-- WEAPON LAWS, weapon laws
-- WARRANTS, warrants
Usage Notes
LCASE
is a synonym for LOWER
.
Last updated
Was this helpful?