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("Boat", "G_te") = false 


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

 
Similar Functions

Like

RegexpMatch

Contains