CONCAT

All functions > STRING > CONCAT

Returns a single concatenated string from a list of strings.

Syntax

Diagram(
  Sequence(
    Terminal("CONCAT"),
    Terminal("("),
    NonTerminal("string"),
    Terminal(","),
    OneOrMore(NonTerminal("string"), Terminal(",")),
    Terminal(")"),
  )
)

Notes

• Empty array returns empty string
• NULL values are treated as empty strings
• No separator between strings (use CONCAT_WS for separator)

Examples

SELECT
    f1 := CONCAT('A', 'B', 'C')  -- Variadic form
;