> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# CallText

> Use the Sigma CallText function to send a request to run a warehouse function that returns a text value.

The **CallText** function sends a request to execute a warehouse function that returns a text value. This is often used to extract and display numbers in a more readable format or to join digits with text or symbols.

**CallText** is a passthrough function.

The functions that can be used with a passthrough function depend on your connected data platform's native SQL functions. For example, on Snowflake connections, browse the [Snowflake SQL function reference](https://docs.snowflake.com/en/sql-reference-functions) to find functions that return a value that matches the datatype of the passthrough function.

With **CallText**, you can use a function that returns a text value.

> **Info**
>
> This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

## Syntax

```sigma
CallText(function_name, argument)
```

Function arguments:

|                   |                                                          |
| :---------------- | :------------------------------------------------------- |
| **function name** | The warehouse function to call.                          |
| **argument**      | One or more arguments to pass to the warehouse function. |

> **Warning**
>
> All arguments must meet the warehouse function’s input requirements. Unsupported arguments result in an invalid formula.

## Example

A table contains a *Revenue* column that provides restaurant revenue data as a number value. Using the **CallText** function, you can execute Snowflake's [TO\_CHAR](https://docs.snowflake.com/en/sql-reference/functions/to_char) function to extract digits and preserve the number format when combining *Revenue* and *Currency* values into a single text string.

```sigma
Concat("$", CallText("TO_CHAR", [Revenue], "999,999,999,999.00"), " ", [Currency])
```

Returns the *Revenue* value as a text string and preserves the number format (999,999.999.00) upon text conversion.

![Screenshot\_2023-04-21\_at\_10.34.01\_AM.png](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/7336af6620d645ba6fdb984fd9f0d8b7c27b95a0380ef4622dc34512e4bb3029/assets/docs-images/cebd220-7.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20261007%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20261007T063201Z&X-Amz-Expires=604800&X-Amz-Signature=32575264c85c966df24c663abe6fa81e5ce5a028df4328426c1c30329ddae49e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [CallLogical](/docs/calllogical)
* [CallNumber](/docs/callnumber)
* [CallVariant](/docs/callvariant)
* [CallDatetime](/docs/calldatetime)