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

# Like

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

## Usage

```
Like(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

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

```
Like("Boat", "G_te") = false
```

**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 “Gemma” and “Jeremy”.\
The Like function is case-sensitive, so string values such as "Emma" returns false. 

```
Like([Name], “%em%”)
```

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/5d7c73163d21b54261d07a4468cc4d258e2b33c9e7a8802f7354260e59a17d18/assets/docs-images/62aa331-mceclip0_1.png)

## Related resources

* [ILike](/docs/ilike)
* [RegexpMatch](/docs/regexpmatch)
* [Contains](/docs/contains)