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
    -- Array of pieces
    f1 := CONCAT_FN(ARRAY('A', 'B', 'C')),
    -- Spaces as separate elements
    f2 := CONCAT_FN(ARRAY('Hello', ' ', 'World'))
;

.CONCAT(...) — chained

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

Edge cases

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