CONCAT (Report Builder)

Concatenates multiple strings together into one. The second string is appended to the first string.

Syntax

string1**&**string2

string1	Specifies the first string.
string2	Specifies the string to append to the first string.

Alternatively, you can use the following syntax to join text items: CONCAT(string1, string2).

If you want a space or other literal characters to appear between the first string and the second string, you must type the space within quotation marks. For example, " ".
You are not limited to the number of strings that you can concatenate at one time.

Formula	Result
First Name & " " & Last Name	Returns each respective instance of the first and last name fields are concatenated with a space between each string, similar to the following: Julia Ilyina Christine Chang

First Name & " " & Last Name

Returns each respective instance of the first and last name fields are concatenated with a space between each string, similar to the following:

Julia Ilyina

Christine Chang