concat
Arguments
Requires two or more arguments of a string value (named groups or constants).
The function also supports a named parameter allow_empty:=yes/no which specifies whether to produce an output if one or more argument is empty (set to "no" by default). By default, the function returns empty string if one or more argument are empty.
Returned Value
A single string value containing all the arguments.
By default, the function joins argument values without any delimiter between them. To get arguments separated by a delimiter, pass delimiters as function arguments at the positions where they should be placed.
For example, concat(A, " ", B) returns "A B".
The delimiter value can be arbitrary string and should be enclosed in quotes if it contains special characters or punctuation signs, such as " ", ":", ",".