Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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).
Remarks
- 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.
Example
| 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 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)