UPPER
- UPPER(value)[source]
Converts a string or string array to uppercase.
For scalar strings: Returns the uppercase version.
For string arrays: Returns a new array where each element is converted to uppercase.
- Parameters:
value (
Operand|str) – The string or string array to convert.- Return type:
- Returns:
A formula containing the uppercase transformation.
- Raises:
ValueError – If the input is not of type STRING or STRING_ARRAY.
Examples
Single string:
UPPER("hello") # Returns "HELLO"
String array:
UPPER(["Hello", "WorLD"]) # Returns ["HELLO", "WORLD"]
``value`` — accepted types
STRING
STRING_ARRAY
Return types
STRING
STRING_ARRAY