# Concat

{% hint style="info" %}
The **`Concat()`** function strings together a list of texts.

This function is NOT SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/~/changes/y5gAfiyi2fILzrLzUUHj/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns a new text that consists of the given <mark style="color:blue;">`values`</mark> that are all concatenated. \
Returns <mark style="color:red;">**`Invalid expression`**</mark> if one of the parameter values is unknown or outside the common valid boundaries.
{% endhint %}

### Syntax

<details>

<summary><code>Concat(</code><mark style="color:blue;"><code>values</code></mark><code>)</code></summary>

`Concat("text1", "text2")` \
\=> *"text1text2"*

</details>

<details>

<summary><code>Concat(</code><mark style="color:blue;"><code>values</code></mark><code>, </code><mark style="color:blue;"><code>delimiter</code></mark><code>)</code></summary>

`Concat(List("text1", "textpart2", "listitem3"), "#SEP#")`\
\=> "*text1#SEP#textpart2#SEP#listitem3"*

</details>

<details>

<summary><code>Concat(</code><mark style="color:blue;"><code>values</code></mark><code>, </code><mark style="color:blue;"><code>delimiter</code></mark><code>, </code><mark style="color:blue;"><code>last_delimiter</code></mark><code>)</code></summary>

`Concat(List("text1", "textpart2", "listitem3"), "#SEP#", "$LAST$")`\
\=> "*text1#SEP#textpart2$LAST$listitem3"*

</details>

### Parameters

<table><thead><tr><th width="203.70825474075613">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>values</code></mark></td><td>text or list</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>a list of text</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>delimiter</code></mark></td><td>text</td><td align="center"></td><td>is placed between the parts when they are joined together.</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>last_delimiter</code></mark></td><td>text</td><td align="center"></td><td>is placed between the last two parts.</td><td>yes</td></tr></tbody></table>