CONCAT_FUNC
All functions > STRING > CONCAT_FUNC
Concatenates an array of strings into a single string.
Syntax
CONCAT_FUNC(exprs)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
strings | ARRAYVARCHAR | Yes | Array of strings to concatenate |
Returns
Single concatenated string
Notes
- Variadic form
CONCAT('A', 'B', 'C')also supported - Empty array returns empty string
- NULL values in array are treated as empty strings
- No separator between strings (use CONCAT_WS for separator)