The Concat() function strings together a list of texts.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a new text that consists of the given values that are all concatenated.
Returns Invalid expression if one of the parameter values is unknown or outside the common valid boundaries.
| Name | Type | Required | Description |
|---|---|---|---|
values
text or list
a list of text
delimiter
text
is placed between the parts when they are joined together.
last_delimiter
text
is placed between the last two parts.