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.

Supported types:

  • STRING

  • STRING_ARRAY

Return type:

Formula

Returns:

A formula containing the uppercase transformation.

Supported types:

  • STRING

  • STRING_ARRAY

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"]