---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/regex-match.md
cuppy_section: docs
cuppy_doc: 2C5X-HDQ9
cuppy_doc_uuid: f94f5665-6193-41ca-b3cc-d7b94e34795e
cuppy_permalink: https://cuppy.io/salesforce/d/2C5X-HDQ9
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/regex-match
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 33a90d22221eedb78037aa99c379d86064e21054f529777a3d59ee9f0de0e3d9
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regex-match.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## Regular Expression Match Operators

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Operators for matching strings against regular expression patterns. Regular expressions provide more powerful pattern matching than `LIKE`.

| Operator | Description |
| --- | --- |
| `~` | Matches regular expression, case-sensitive |
| `~*` | Matches regular expression, case-insensitive |
| `!~` | Doesn’t match regular expression, case-sensitive |
| `!~*` | Doesn’t match regular expression, case-insensitive |

*   `<string>`: The string to match against.
*   `<pattern>`: The regular expression pattern.

Returns a boolean value indicating whether the string matches (or does not match) the pattern.

*   Regular expressions are more powerful than `LIKE` patterns, supporting complex patterns like repetition, alternation, and character classes.
*   Unlike `LIKE`, regular expressions match anywhere within the string by default. Use `^` and `$` anchors to match the start and end of the string.
*   For detailed regex syntax, see [Regular Expression Syntax](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching.html#regular-expression-syntax).

Match a pattern with case sensitivity.

Returns `true`.

Returns `false` because case does not match.

Match a pattern ignoring case.

Returns `true`.

Check that a string does not match a pattern.

Returns `true` because case-sensitive match fails.

Returns `true` because the pattern is not found.

Match one of multiple patterns.

Returns `true` because the string contains ‘b’.

Match patterns at the beginning of a string.

Returns `true` because the string starts with ‘a’.

Returns `false` because the string does not start with ‘b’ or ‘c’.

*   [LIKE / ILIKE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/like.html)
*   [REGEXP_LIKE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regexp-like.html)
*   [Regular Expression Syntax](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching.html#regular-expression-syntax)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->