Concat(Text value1, Text value2, …, Text valueN)
This function returns a string that results from the concatenation, or joining, of two or more string values in an end-to-end manner.
Parameters
- value
- A text value to concatenate with the other values.
Returns
Text
Remarks
Concat takes a variable number of text arguments and concatenates (or joins) them into a single string. It requires a minimum of two input arguments. Concat implicitly converts null values to empty strings.
Examples
Concat("Happy ", "Birthday ", "11", "/", "25")
returns "Happy Birthday 11/25".Concat("John", null, "Doe")
returns "JohnDoe".