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