---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/like.md
cuppy_section: docs
cuppy_doc: GVF7-AQFW
cuppy_doc_uuid: 11704f09-7bcf-4781-8e58-db70cdeb2f4f
cuppy_permalink: https://cuppy.io/salesforce/d/GVF7-AQFW
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/like
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 806218690b2582bb36cb794b4060f8512e35d37aadfec5bd177fe00283f0f341
# 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/like.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.

## `LIKE` / `ILIKE`

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

Pattern matching operator that checks whether a string matches a specified pattern using wildcards. `LIKE` is case-sensitive, but `ILIKE` is case-insensitive.

*   `<string>`: The string to match against.
*   `<pattern>`: The pattern to match, which can contain wildcard characters.

*   `<escape_character>`: The character used to escape wildcard characters. Defaults to backslash (`\`).

Returns a boolean value indicating whether the string matches the pattern.

*   **Wildcards**: `_` matches any single character. `%` matches any sequence of zero or more characters.
*   **Full string match**: `LIKE` always covers the entire string. Use `%` at the start and end to match anywhere within a string.
*   **Escaping**: To match a literal `_` or `%`, precede it with the escape character.
*   **No escape**: Use `ESCAPE ''` to disable escape character handling.

| Operator | Equivalent |
| --- | --- |
| `~~` | `LIKE` |
| `~~*` | `ILIKE` |
| `!~~` | `NOT LIKE` |
| `!~~*` | `NOT ILIKE` |

Match strings using wildcards.

Returns `true`.

Returns `true` because `%` matches any sequence of characters.

Returns `true` because `_` matches any single character.

Use `ILIKE` for case-insensitive matching.

Returns `true`.

Match literal wildcard characters.

Returns `true` because `\_` matches a literal underscore.

Use a custom escape character.

Returns `true` using `!` as the escape character.

Find a pattern anywhere within a string.

Returns all products with “widget” anywhere in the name.

*   [Regular Expression Match Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regex-match.html)
*   [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string.html)


---
<!-- 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 -->