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

# String Functions

## `regexp_count`

returns number of matches of regular expression pattern in subject
*Supported Signatures*

```sql theme={null}
function regexp_count(varchar, varchar) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0), varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_count)

## `regexp_instr`

returns position at which the subject matches the regular expression pattern
*Supported Signatures*

```sql theme={null}
function regexp_instr(varchar, varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_instr)

## `regexp_like`

returns TRUE if subject RLIKE pattern
*Supported Signatures*

```sql theme={null}
function regexp_like(varchar, varchar) returns boolean
function regexp_like(varchar, varchar, varchar) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_like)

## `regexp_replace`

replaces substring in subject matching a regular expression pattern
*Supported Signatures*

```sql theme={null}
function regexp_replace(varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_replace)

## `regexp_substr`

returns substring in subject which matches the regular expression pattern
*Supported Signatures*

```sql theme={null}
function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_substr)

## `regexp_substr_all`

returns all substring in subject which matches the regular expression pattern
*Supported Signatures*

```sql theme={null}
function regexp_substr_all(varchar, varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regexp_substr_all)