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


Like(string, pattern)

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


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

Related resources