CONCATENATE ER function
The CONCATENATE function returns all the specified text strings as a String value after they have been joined into one string.
Syntax
CONCATENATE (text 1[, text 2, …, text N])
Arguments
text 1: String
A reference to a data source of the String data type. This argument is required.
text N: String
A reference to a data source of the String data type. These additional arguments are optional.
Return values
String
The resulting text value.
Example
CONCATENATE ("abc", "def") returns "abcdef".
Usage notes
The expression "abc" & "def" also returns "abcdef".