CONCAT(...)

All functions > STRING > CONCAT(...)

Returns a single concatenated string from a list of strings.

Syntax

CONCAT(string, string, …)  ·  CONCAT_FN(ARRAY[…])

CONCAT(string, string, …)  ·  CONCAT_FN(ARRAY[…])

Notes

• Variadic CONCAT(a, b, …) is implemented the same way as CONCAT_FN(ARRAY[…])
• Every argument must be VARCHAR: bare NULL is untyped and fails inference—use NULL(VARCHAR) or COALESCE(expr, '')
• NULL entries in the bundled list are omitted—they are not treated as empty strings; literal '' is kept and participates. Use COALESCE when you need a visible empty segment
• No separator between pieces; use CONCAT_WS for a delimiter
• For binary left || right (and left-associative chains), see Related operators (||)

Related Functions

• CONCAT(...)

Examples

CONCAT(...)

SELECT
    f1 := CONCAT('A', 'B', 'C'), -- Several pieces
    f2 := CONCAT('Hello', ' ', 'World') -- Includes a space argument
;

Edge cases

SELECT
    f1 := CONCAT('A', NULL(VARCHAR), 'B') -- NULL propagates
;