CONCAT(...)

All functions > STRING > CONCAT(...)

Joins an array of VARCHAR values into one string with no delimiter (array form of CONCAT).

Signatures

Returns: Concatenated string

CONCAT_FN(strings: ARRAY(VARCHAR)) → VARCHAR

Notes

• Equivalent to variadic CONCAT(...) after the parser bundles arguments into an array
• Each element must be VARCHAR; for nullable pieces use NULL(VARCHAR) or COALESCE
• NULL list elements are omitted (see CONCAT operator notes)

Related operators

• CONCAT(...)

• || [concatenation]

Examples

CONCAT_FN(...)

SELECT
    f1 := CONCAT_FN(ARRAY['A', 'B', 'C']), -- Array of pieces
    f2 := CONCAT_FN(ARRAY['Hello', ' ', 'World']) -- Spaces as separate elements
;

.CONCAT(...) — chained

SELECT
    f1 := 'A'.CONCAT('B', 'C') -- Chained variadic call on a VARCHAR base
;

Edge cases

SELECT
    f1 := CONCAT_FN(ARRAY['One']), -- Single element
    f2 := CONCAT_FN(ARRAY['A', NULL(VARCHAR), 'B']) -- NULL propagates
;