UPPER
Returns the input expression with all the characters converted to uppercase.
Syntax
UPPER(expression varchar) → varchar
expression: String to convert to uppercase.
Examples
SELECT UPPER('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
UPPER
is a synonym for UCASE
.
Last updated
Was this helpful?