UPPER

Returns a string with all characters changed to uppercase.

Analyze Syntax

func.unhex(<expr>)

Analyze Examples

func.upper('hello, plaidcloud lakehouse!')
+--------------------------------------------+
| func.upper('hello, plaidcloud lakehouse!') |
+--------------------------------------------+
| 'HELLO, PLAIDCLOUD LAKEHOUSE!'             |
+--------------------------------------------+

SQL Syntax

UPPER(<str>)

Aliases

Return Type

VARCHAR

SQL Examples

SELECT UPPER('hello, databend!'), UCASE('hello, databend!');

┌───────────────────────────────────────────────────────┐
 upper('hello, databend!')  ucase('hello, databend!') 
├───────────────────────────┼───────────────────────────┤
 HELLO, DATABEND!           HELLO, DATABEND!          
└───────────────────────────────────────────────────────┘
Last modified April 22, 2024 at 5:52 PM EST: string functions updated (f7f7143)