CONCAT_OF_ANY

Description

CONCAT_OF_ANY is the flexible counterpart of CONCAT.

It combines multiple lists into a single piece of text if these values exist.

Example

p is Person
CONCAT_OF_ANY(
    '+',
    TRIM_LEFT(p.phone_country_code, '0'),
    TRIM_LEFT(p.phone_number, '0')
)

This concatenates the +, the phone country code, and the phone number, skipping any of these values that are not provided.\