# CONCAT

```
CONCAT(expr1, expr2, expr3)
```

Returns the string representation of concatenating each `expression` in the list. Null fields are left out.

Available in:

| Processors | SQL Studio |
| ---------- | ---------- |
| ✓          | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT 
    CONCAT(first_name,' ', last_name),
    first_name, 
    last_name 
FROM users-topic
LIMIT 1;
```

*Output:*

```json
{
  "value": {
    "CONCAT": "Jose Hood",
    "first_name": "Jose",
    "last_name": "Hood"
  }
}
```