> 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

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.

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

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

Function arguments:

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

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.

```
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://files.buildwithfern.com/sigma.docs.buildwithfern.com/7336af6620d645ba6fdb984fd9f0d8b7c27b95a0380ef4622dc34512e4bb3029/assets/docs-images/cebd220-7.png)

## Related resources

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