> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

# String & binary functions

> Snowflake string & binary functions supported in Snowflake compatibility mode.

<span className="feature-tag">Preview</span>

Snowflake [string & binary functions](https://docs.snowflake.com/en/sql-reference/functions-string) in [Snowflake compatibility mode](/reference-sql/snowflake/overview).

| Function                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Support          | Notes                                        |
| :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :--------------- | :------------------------------------------- |
| `ASCII`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `CONCAT`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Supported        |                                              |
| `LEFT`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Supported        |                                              |
| `LENGTH`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Supported        |                                              |
| `LIKE`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Supported        |                                              |
| `LOWER`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `LPAD`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Supported        |                                              |
| `LTRIM`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `MD5`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Supported        |                                              |
| `OCTET_LENGTH`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Supported        |                                              |
| `POSITION`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Supported        |                                              |
| `REPEAT`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Supported        |                                              |
| `REVERSE`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Supported        |                                              |
| `RIGHT`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `RPAD`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Supported        |                                              |
| `RTRIM`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `SPLIT_PART`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Supported        |                                              |
| `SPLIT`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `SUBSTRING`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Supported        |                                              |
| `SUBSTR`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Supported        |                                              |
| `TRIM`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Supported        |                                              |
| `UPPER`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Supported        |                                              |
| `CONTAINS`, `REPLACE`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | With limitations | Available for some argument types only.      |
| `SOUNDEX`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | With limitations | Runs, but the result differs from Snowflake. |
| `BASE64_ENCODE`, `BINARY_AS_STRING`, `BIT_LENGTH`, `CHAR`, `CHARINDEX`, `CHR`, `CONCAT_WS`, `EDITDISTANCE`, `ENDSWITH`, `FORMAT_STRING_TEMPLATE`, `FUZZY_SUBSEQUENCE_SCORE`, `HEX_ENCODE`, `ILIKE`, `INITCAP`, `INSERT`, `JACCARD_SIMILARITY`, `JAROWINKLER_SIMILARITY`, `LEN`, `LIKE_ANY`, `MD5_BINARY`, `MD5_HEX`, `RTRIMMED_LENGTH`, `SHA1`, `SHA1_BINARY`, `SHA1_HEX`, `SHA2`, `SHA2_BINARY`, `SHA2_HEX`, `SOUNDEX_P123`, `SPACE`, `STARTSWITH`, `STRING_AS_BINARY`, `STRTOK`, `STRTOK_TO_ARRAY`, `TRANSLATE`, `TRY_BASE64_DECODE_BINARY`, `TRY_BASE64_DECODE_STRING`, `TRY_HEX_DECODE_BINARY`, `TRY_HEX_DECODE_STRING`, `TRY_VALIDATE_UTF8`, `UNICODE` | Not supported    |                                              |

## Limitations

`SOUNDEX` differs in the case of the leading character only: `SOUNDEX('robert')` returns `R163`, where Snowflake returns `r163`.