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