Edit

CONCATENATE ER function

  • Article

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

Additional resources

Text functions