title	description	ms.reviewer	ms.topic	ms.date
The case-insensitive !endswith string operator	Learn how to use the !endswith string operator to filter records for data that excludes a case-insensitive ending string.	alexans	reference	01/10/2023

!endswith operator

Filters a record set for data that excludes a case-insensitive ending string.

Performance tips

When possible, use the case-sensitive !endswith_cs.

T | where col !endswith (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.

[!div class="nextstepaction"] Run the query

StormEvents
| summarize Events=count() by State
| where State !endswith "is"
| where Events > 2000
| project State, Events

Output