Skip to main content

UPPER

Returns a string with all characters changed to uppercase.

Syntax

UPPER(<str>)

Aliases

Return Type

VARCHAR

Examples

SELECT UPPER('Hello, Databend!'), UCASE('Hello, Databend!');

┌───────────────────────────────────────────────────────┐
│ upper('hello, databend!')ucase('hello, databend!')
├───────────────────────────┼───────────────────────────┤
│ HELLO, DATABEND! │ HELLO, DATABEND!
└───────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today