CONCAT_WS_FUNC
All functions > STRING > CONCAT_WS_FUNC
Concatenates an array of strings with a separator between each element.
Syntax
CONCAT_WS_FUNC(delimiter, exprs)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
separator | VARCHAR | Yes | String to insert between each element |
strings | ARRAYVARCHAR | Yes | Array of strings to concatenate |
Returns
Concatenated string with separator between elements
Notes
- Variadic form
CONCAT_WS('-', 'A', 'B')also supported - Empty array returns empty string
- NULL values in array are skipped
- Separator not added for skipped NULL values