# CONCAT

| **Description** | The **`CONCAT()`** function allows you to combine multiple text strings into one, which can be useful for creating dynamic labels, combining names, or constructing sentences from text fragments. |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Syntax**      | CONCAT(**`text1`**, **`text2`**, **`…`**)                                                                                                                                                          |

1. **`text1`**, **`text2`**, **`...`** : These are the text strings you want to concatenate. You can include multiple text strings separated by commas.

## Example

### Table

| Column 1 | Column 2 | Column 3 |
| -------- | -------- | -------- |
| Hello    | ,        | world!   |
| This     | is a     | test     |
| Savant   | is       | amazing  |

### Function

```
CONCAT(`Column 1`, `Column 2`, `Column 3`)
```

### Results

| CONCAT (text)     |
| ----------------- |
| Hello, world!     |
| This is a test    |
| Savant is amazing |
