The case-insensitive startswith string operator
Learn how to use the case-insensitive startswith string operator to filter a record set with a case-insensitive string starting sequence.
Filters a record set for data with a case-insensitive string starting sequence.
Performance tips
When possible, use the case-sensitive startswith_cs.
Syntax
T | where col startswith (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 "Lo"
| where event_count > 10
| project State, event_count
Output
| State | event_count |
|---|---|
| LOUISIANA | 463 |
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.