CONCATENATE
Syntax
CONCATENATE (string_expression, string_expression, ...)
Description
Joins two or more strings into a single string.
Arguments
| string_expression | A string of one or more characters. All data is converted to a string before concatenation. |
Returns
A single string.
Remarks
You can also use the Concatenate operator, & , within formulas.
Examples
CONCATENATE ("Mary ", "had ","a ","little ", "lamb.")
Returns: Mary had a little lamb.
If LastName (Smythe) and FirstName (Joe) are fields in the source:
(MyEntity.LastName & ", " & MyEntity.FirstName)
Returns: Smythe, Joe
(MyEntity.FirstName, MyEntity.LastName)
Returns: JoeSmythe
(MyEntity.FirstName, " ", MyEntity.LastName)
Returns: Joe Smythe