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