topic Re: how can i use like and not like in the same query? in Splunk Search https://community.splunk.com/t5/Splunk-Search/how-can-i-use-like-and-not-like-in-the-same-query/m-p/602456#M209704 <P>The negation operator is <FONT face="courier new,courier">NOT</FONT>.</P><P>&nbsp;</P><LI-CODE lang="markup">| where (like(RouteCode, "50%") AND NOT like(RouteCode, "503%"))</LI-CODE><P>&nbsp;</P> Mon, 20 Jun 2022 18:55:56 GMT richgalloway 2022-06-20T18:55:56Z how can i use like and not like in the same query? https://community.splunk.com/t5/Splunk-Search/how-can-i-use-like-and-not-like-in-the-same-query/m-p/602434#M209696 <P>| where like(RouteCode, "50%") AND !like(RouteCode, "503%")<BR /><BR />I am trying to show Routecode 501,2, -- anyother not 503.</P> Mon, 20 Jun 2022 16:32:12 GMT https://community.splunk.com/t5/Splunk-Search/how-can-i-use-like-and-not-like-in-the-same-query/m-p/602434#M209696 ashidhingra 2022-06-20T16:32:12Z Re: how can i use like and not like in the same query? https://community.splunk.com/t5/Splunk-Search/how-can-i-use-like-and-not-like-in-the-same-query/m-p/602456#M209704 <P>The negation operator is <FONT face="courier new,courier">NOT</FONT>.</P><P>&nbsp;</P><LI-CODE lang="markup">| where (like(RouteCode, "50%") AND NOT like(RouteCode, "503%"))</LI-CODE><P>&nbsp;</P> Mon, 20 Jun 2022 18:55:56 GMT https://community.splunk.com/t5/Splunk-Search/how-can-i-use-like-and-not-like-in-the-same-query/m-p/602456#M209704 richgalloway 2022-06-20T18:55:56Z