UCASE

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

Syntax

UCASE(expression varchar) → varchar

expression: String to convert to uppercase.

Examples

UCASE example

SELECT UCASE('a guide to data lakehouses')
-- A GUIDE TO DATA LAKEHOUSES

UCASE 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

UCASE is a synonym for UPPER.

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.