The case-sensitive endswith_cs string operator

Learn how to use the endswith_cs operator to filter a record set for data with a case-sensitive ending string.

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

Performance tips

T | where col endswith_cs (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 “NA”. This is a case-sensitive search.

StormEvents
| summarize Events = count() by State
| where State endswith_cs "NA"

Output

Was this page helpful?

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