---
schema_version: "1"
id: ee4b63519cc2a77c3b9c2597f7defbe23a0f249352ff6793ab37cca8bb95f749
title: string_to_number
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-saql-functions-string-stn.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-string-stn.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 0218731010cc1cbb8dae40a18e6bbe19c172ee8207d9ee75422b69ea4c5286ae
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# string_to_number

Converts a string literal to a number literal.

## Syntax

`string_to_number(string)`

## Usage

If the string can't be parsed as a number or contains a separator, such as a comma, the query fails.

## Example

```nolang
-- creates a field called "Number" that contains the number 12345

q = foreach q generate string_to_number("12345") as 'Number';
```