# ToString

{% hint style="info" %}
The **`ToString()`** function converts a <mark style="color:blue;">value</mark> to <mark style="color:green;">text</mark>.

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="warning" %}
Note: this function uses the language setting of a portal when converting a value.
{% endhint %}

{% hint style="success" %}
Returns a text representation of <mark style="color:blue;">`value`</mark>.&#x20;
{% endhint %}

### Syntax

<details>

<summary><code>ToString(</code><mark style="color:blue;"><code>value</code></mark><code>)</code></summary>

`ToString(Date(2016, 12, 31, 15, 45))`\
\=> *"zaterdag 31 december 2016 15:45" {according to Dutch language}*

`ToString(unknownstring)`\
*=> unknown*

`ToString(765432123456.78901, "#,##0.00")`\
*=> "765432123456.78901"*&#x20;

`ToString('World regions'.'EMEA')`\
*=> "EMEA"*

</details>

### Parameters

<table><thead><tr><th width="150">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>value</code></mark></td><td></td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>a value of any type.</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>format</code></mark></td><td>text</td><td align="center"></td><td>a text with the format to which <mark style="color:blue;"><code>value</code></mark> must be converted. This parameter only applies when converting a <code>datetime</code>, <code>duration</code> or <code>number</code>.</td><td></td></tr></tbody></table>