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
    f1 := CONCAT_WS_FN('-', ARRAY['A', 'B', 'C']), -- Separator and array of strings
    f2 := CONCAT_WS_FN(', ', ARRAY['Apple', 'Banana']) -- Comma–space delimiter
;

Edge cases

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