> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# ILike

> Returns true if the string value matches the case-insensitive pattern.

Returns true if the string value matches the case-insensitive pattern.

## Usage

`ILike(string, pattern)`

**string** (required) The text string that is being searched.

**pattern** (required) The search pattern. An '\_' matches any character. A '%' matches any sequence of zero or more characters.

## Examples

```
ILike("Piano", "P_ano") = true
```

```
ILike("Piano", "p_ANO") = true
```

```
ILike("Piano", "p%o") = true
```

**Try it in Sigma Sample Data**

In Sigma's sample baby name data, the following formula returns *true* for values in the `[Name]` column that include “em”, like "Emma", “Gemma” and “Jeremy”.

```
ILike([Name], "%em%")
```

![Table with Name and ILike columns for Emma, Gemma, and Jeremy, all returning True.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/adad7eabcdc88681d423d9de4eab0752368b4bc553bfefcd445a4b87d379aee3/assets/docs-images/9dcef1f-mceclip0.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260817%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260817T052108Z&X-Amz-Expires=604800&X-Amz-Signature=8beb09674db178ef34ffb674399613f6151b47a0f1ccec384fc2b1bbf5832cbb&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [Like](/docs/like)
* [RegexpMatch](/docs/regexpmatch)
* [Contains](/docs/contains)