Concat

concat concatenates two or more strings.

Syntax

Copy

concat(expression1, expression2 [, expression3 ...])

Arguments

concat takes two or more string expressions as arguments.

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

Return type

String

Examples

The following example concatenates three string fields and adds appropriate spacing.

Copy

concat(salutation, ' ', firstName, ' ', lastName)

The following are the given field values.

Copy

salutation     firstName          lastName
-------------------------------------------------------
Ms.            Li                  Juan
Dr.            Ana Carolina        Silva
Mr.            Nikhil              Jayashankar

For these field values, the following values are returned.

Copy

Ms. Li Juan
Dr. Ana Carolina Silva
Mr. Nikhil Jayashankar

The following example concatenates two string literals.

Copy

concat('Hello', 'world')

The following value is returned.

Copy

Helloworld