Skip to main content

CONCAT

Returns a string that is the result of concatenating two or more string values.

Syntax​

string CONCAT(params string[] values)

Example​

You can join two or more columns into a single string by entering the column name for each. Each column needs to be separated by a comma in the function.

Unless specified the values will have no separator (e.g. a space, dash, semi-colon, comma etc.)

CONCAT(Value1, Value2)

or

CONCAT("Telephone", "-", "0044 1424 863 450")

Will return "Telephone - 0044 1424 863 450".

or

Customer full name from the Customer Database, using CustFirstname = John and CustSurname = Smith separated by a space.

CONCAT("CustFirstname", " ", "CustSurname")

Will return "John Smith".