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%β)
Updated 4 months ago
Related resources