The case-sensitive startswith string operator
Learn how to use the startswith string operator to filter a record set with a case-sensitive string starting sequence.
Filters a record set for data with a case-sensitive string starting sequence.
Performance tips
Syntax
T | where col startswith_cs (expression)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string | ✔️ | The tabular input to filter. |
| col | string | ✔️ | The column used to filter. |
| expression | string | ✔️ | The expression by which to filter. |
Returns
Rows in T for which the predicate is true.
Example
StormEvents
| summarize event_count=count() by State
| where State startswith_cs "I"
| where event_count > 2000
| project State, event_count
Output
| State | event_count |
|---|---|
| IOWA | 2337 |
| ILLINOIS | 2022 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.