LOWER

LOWER(value)

Converts a string or string array to lowercase.

• For scalar strings: Returns the lowercase version.

• For string arrays: Returns a new array where each element is converted to lowercase.

Parameters:

value (Operand | str) –

The string or string array to convert.

Supported types:

• STRING

• STRING_ARRAY

Return type:

Formula

Returns:

A formula containing the lowercase transformation.

Supported types:

• STRING

• STRING_ARRAY

Raises:

ValueError – If the input is not of type STRING or STRING_ARRAY.

Examples

Single string:

LOWER("HELLO")
# Returns "hello"

String array:

LOWER(["Hello", "WORLD"])
# Returns ["hello", "world"]