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 only combines the nationality with the optional second nationality if there is a second nationality provided.