how can i use like and not like in the same query?

[ashidhingra]

| where like(RouteCode, "50%") AND !like(RouteCode, "503%")

I am trying to show Routecode 501,2, -- anyother not 503.

[richgalloway · Accepted solution]

The negation operator is NOT.

| where (like(RouteCode, "50%") AND NOT like(RouteCode, "503%"))