The case-insensitive =~ (equals) string operator

Learn how to use the =~ (equals) operator to filter a record set for data with a case-insensitive string.

Filters a record set for data with a case-insensitive string.

The following table provides a comparison of the == (equals) operators:

Operator	Description	Case-Sensitive	Example (yields `true`)
`==`	Equals	Yes	`"aBc" == "aBc"`
`!=`	Not equals	Yes	`"abc" != "ABC"`
`=~`	Equals	No	`"abc" =~ "ABC"`
`!~`	Not equals	No	`"aBc" !~ "xyz"`

For more information about other operators and to determine which operator is most appropriate for your query, see datatype string operators.

Performance tips

When possible, use == - a case-sensitive version of the operator.

T | where col =~ (expression)

Name	Type	Required	Description
T	`string`	✔️	The tabular input whose records are to be filtered.
col	`string`	✔️	The column to filter.
expression	`string`	✔️	The expression used to filter.

Rows in T for which the predicate is true.

The State values in the StormEvents table are capitalized. The following query matches columns with the value “KANSAS”.

StormEvents
| where State =~ "kansas"
| project EventId, State

The following table only shows the first 10 results. To see the full output, run the query.

Was this page helpful?

Sorry to hear that. Please tell us how we can improve.