The case-sensitive == (equals) string operator

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

Filters a record set for data matching a case-sensitive string.

The following table provides a comparison of the == 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

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.

Returns the rows in T for which the predicate is true.

The following example returns the rows in the StormEvents table where the State column equals “kansas”. This is a case-sensitive search.

StormEvents
| where State == "kansas"
| count

Count
0

The following example returns the rows in the StormEvents table where the State column equals “KANSAS”. This is a case-sensitive search.

StormEvents
| where State == "KANSAS"
| count

Count
3,166

Was this page helpful?

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