The case-sensitive hasprefix_cs string operator

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

For best performance, use strings of three characters or more. hasprefix_cs searches for indexed terms, where a term is three or more characters. If your term is fewer than three characters, the query scans the values in the column, which is slower than looking up the term in the term index.

Performance tips

Syntax

T | where Column hasprefix_cs (Expression)

Parameters

Returns

Rows in T for which the predicate is true.

Examples

StormEvents
| summarize event_count=count() by State
| where State hasprefix_cs "P"
| count 

StormEvents
| summarize event_count=count() by State
| where State hasprefix_cs "P"
| project State, event_count