UCASE
Returns the input expression with all the characters converted to uppercase.
Syntax
UCASE(expression varchar) → varchar
expression: String to convert to uppercase.
Examples
SELECT UCASE('a guide to data lakehouses')
-- A GUIDE TO DATA LAKEHOUSES
SELECT DayOfWeek, UCASE(DayOfWeek)
FROM eth.recent_blocks
LIMIT 3
-- DayOfWeek, EXPR$1
-- Friday, FRIDAY
-- Friday, FRIDAY
-- Monday, MONDAY
Usage Notes
UCASE
is a synonym for UPPER
.
Last updated
Was this helpful?