| where like(RouteCode, "50%") AND !like(RouteCode, "503%")
I am trying to show Routecode 501,2, -- anyother not 503.
The negation operator is NOT.
| where (like(RouteCode, "50%") AND NOT like(RouteCode, "503%"))
The negation operator is NOT.
| where (like(RouteCode, "50%") AND NOT like(RouteCode, "503%"))