The case-insensitive endswith string operator

Learn how to use the endswith operator to filter a record set for data with a case-insensitive string.

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

Performance tips

For faster results, use the case-sensitive version of an operator. For example, use endswith_cs instead of endswith.

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.

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 ends with “SAS”.

StormEvents
| summarize Events=count() by State
| where State endswith "sas"
| where Events > 10
| project State, Events

Output

State	Events
KANSAS	3166
ARKANSAS	1028

Was this page helpful?

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