JOIN

Returns the strings appended to one another using the delimiter.

Usage examples 

JOIN("-", "a", "b", "c")

Syntax 

JOIN ( delimiter, value1, [ value2, ... ] )

  • delimiter - any string expression representing the delimiter.

  • value1 - any string expression for values to be appended using delimiter.

  • value2 - any string expression for values to be appended using delimiter.

Returns 

string - the appended string using the delimiter.

Functions reference