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.
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".