concat_strings¶
Description¶
Return the concatenation of all string arguments. Null values are represented as empty string, i.e., “”.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
concat_strings(str_1, str_2, ...)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
str |
string |
no |
yes |
none |
Examples¶
make_col foo:concat_strings(colstr1, " ", colstr2)
Make a new column ‘foo’ that is the concatenation of ‘colstr1’, “ “, and ‘colstr2’
make_col foo:concat_strings(colstr1, ",", nullValue)
Make a new column ‘foo’ that is the concatenation of ‘colstr1’, “,”, and “”
Aliases¶
strcat (deprecated), string_concat (deprecated)