concat
Joins several elements into one string.
Any data type can be used. Types other than string are converted to string before the function is applied.
Information noteNote: This function can be used both as an aggregation function or a string
function, depending on the number of arguments.
Arguments
At least two strings to concatenate, or an element containing an array or a group of elements to concatenate.
Examples
| Expression | Result |
|---|---|
| concat("Hello ", "World!") | "Hello World!" |
| concat("Hello", null) | "Hello" |