CONCAT_WS

All functions > STRING > CONCAT_WS

Returns a concatenated string from a list of strings with a separator between each element.

Syntax

Diagram(
  Sequence(
    Terminal("CONCAT_WS"),
    Terminal("("),
    NonTerminal("separator"),
    Terminal(","),
    NonTerminal("string"),
    Terminal(","),
    OneOrMore(NonTerminal("string"), Terminal(",")),
    Terminal(")"),
  )
)
ParameterTypeRequiredDescription
separatorVARCHARYesString to insert between each element
stringVARCHARYesString to concatenate

Notes

  • Empty array returns empty string
  • NULL values are skipped
  • Separator not added for skipped NULL values

Examples

FeatureQL
SELECT
    f1 := CONCAT_WS('-', 'A', 'B', 'C')  -- Variadic form with dash
;
Result
f1 VARCHAR
A-B-C

Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19