Skip to main content

Categories: String

UPPER

Returns the input expression with all the characters converted to uppercase.

Syntax​

UPPER(expression varchar) → varchar​

  • expression: String to convert to uppercase.

Examples

UPPER example 
SELECT UPPER('a guide to data lakehouses')
-- A GUIDE TO DATA LAKEHOUSES
UPPER example 
SELECT DayOfWeek, UCASE(DayOfWeek) 
  FROM Samples."samples.dremio.com"."SF_incidents2016.json" 
  LIMIT 3
-- DayOfWeek, EXPR$1
-- Friday, FRIDAY
-- Friday, FRIDAY
-- Monday, MONDAY

Usage Notes​

UPPER is a synonym for UCASE.