concat()

Concatenates multiple strings or lists. NULL inputs are skipped. See also operator ||.

Reference: DuckDB 1.4.4

Arguments & returns

concat(value, …)

Scalar
Overload link value … Varargs Returns
#01 ANY ANY ANY

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

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

Engine example · Run to view results.

More examples

concat example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

PostgreSQLconcat()

Same function