concat_ws()

Concatenates many strings, separated by separator. NULL inputs are skipped.

Reference: DuckDB 1.5.6

Arguments & returns

concat_ws(separator, string, …)

Scalar
Overload link separatorstring … Varargs Returns
#01 VARCHARANY ANY VARCHAR

… accepts a variable number of arguments of the type shown.

Example

concat_ws example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

Apache Sparkconcat_ws()

Same function