CONCAT_WS(...)

All functions > STRING > CONCAT_WS(...)

Joins an array of VARCHAR values with a delimiter between elements (array form of CONCAT_WS).

Signatures

Returns: Joined string

CONCAT_WS_FN(separator: VARCHAR, strings: ARRAY(VARCHAR)) → VARCHAR

Notes

• Same semantics as variadic CONCAT_WS(sep, ...) once arguments are bundled into an array
• NULL array elements are skipped (no delimiter-only gap); use COALESCE(x, '') if you need an empty segment and separators around it

Related operators

• CONCAT_WS(...)

Examples

CONCAT_WS_FN(...)

SELECT
    -- Separator and array of strings
    f1 := CONCAT_WS_FN('-', ARRAY('A', 'B', 'C')),
    -- Comma–space delimiter
    f2 := CONCAT_WS_FN(', ', ARRAY('Apple', 'Banana'))
;

Edge cases

SELECT
    -- Single-space separator
    f1 := CONCAT_WS_FN(' ', ARRAY('Hello', 'World')),
    -- NULL element omitted
    f2 := CONCAT_WS_FN('-', ARRAY('A', NULL(VARCHAR), 'B'))
;