# MV_CONCAT

The MV_CONCAT function converts a multivalued string expression into a single value by concatenating all values, separated by a specified delimiter.

## Syntax

`MV_CONCAT(string, delim)`

### Parameters

#### string

Multivalue expression containing the values to concatenate.

#### delim

Delimiter used to separate the concatenated values.

## Examples

Concatenates the values in the multivalued string column `a` into a single string, separated by a comma and space.
```esql
ROW a=["foo", "zoo", "bar"]
| EVAL j = MV_CONCAT(a, ", ")
```

Concatenates the numeric values in the multivalued column `a` into a single string, separated by a comma and space, after converting them to strings.
```esql
ROW a=[10, 9, 8]
| EVAL j = MV_CONCAT(TO_STRING(a), ", ")
```
