ILike
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 will return true for values in the [Name]
column that include βemβ, like "Emma", βGemmaβ and βJeremyβ.Β
ILike(\[Name\], β%em%β)
Updated 5 months ago
Related resources