UPPER
Converts the string to uppercase letters.
Syntax
Arguments
STRING
STRING
Type: string
A sequence of characters.
Returns
Type: string
STRING
in uppercase letters.
Examples
"SELECT UPPER('a') = 'A' AND UPPER('abc') = 'ABC' AND UPPER('123') = '123' AND UPPER('abc') = 'ABC' AND UPPER('-=@#$') = '-=@#$' AND UPPER(null) is null AND UPPER(CAST(null as varchar)) is null"
STRING
Output
a
A
abc
ABC
123
123
abc
ABC
-=@#$
-=@#$
null
null
Transformation job example
SQL
Query result
customer_firstname
upper_firstname
Charles
CHARLES
Angela
ANGELA
Margaret
MARGARET
Last updated