JOIN (STRING)

Joins two or more text values with a separator in-between.

JOIN(separatorString, value1, value2, ...)

join(':::', ‘A’, ‘B’, ‘C’)

returns A:::B:::C

Like concat() but uses the first argument as a separator.