> 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%”)
```

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/adad7eabcdc88681d423d9de4eab0752368b4bc553bfefcd445a4b87d379aee3/assets/docs-images/9dcef1f-mceclip0.png)

## Related resources

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