Operators Operator

||

Concatenates two strings, lists, or blobs. Any NULL input results in NULL. See also concat(arg1, arg2, ...) and list_concat(list1, list2, ...).

Reference: DuckDB 2.0.0

Operands & returns

arg1 || arg2

Operator
Overload link arg1arg2 Returns
#01 ANYANY ANY
|| example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

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

Engine example · Run to view results.

|| example 3
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.