concat
Join text values or lists into one value. Missing values are skipped, while the || operator returns a missing value if any input is missing.
Try an expression
In Formula, enter the expression and set Output type to VARCHAR.
Expression
concat('Hello', ' ', 'World')Result
'Hello World'To use your own data, replace the example values with column names. Keep format strings and other options as written.
Arguments and types
concat(value, ...)- value
- Any value
Supported signatures (1)
concat(value: ANY, ...: ANY) → ANYThe result type can depend on the input types. See DuckDB for the full argument rules.
Things to know
With a missing first argument
concat(NULL::VARCHAR, ' ', 'World')' World'
Function metadata from DuckDB, used under the MIT license.