upper.md

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

UPPER

Syntax

UPPER(expression varchar) → varchar

• expression: String to convert to uppercase.

Examples

{% code title="UPPER example" %}

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

{% endcode %}

{% code title="UPPER example" %}

SELECT DayOfWeek, UCASE(DayOfWeek) 
  FROM eth.recent_blocks 
  LIMIT 3

-- DayOfWeek, EXPR$1
-- Friday, FRIDAY
-- Friday, FRIDAY
-- Monday, MONDAY

{% endcode %}

Usage Notes

UPPER is a synonym for UCASE.