title: Log Parser: HAVING Wildcards
body: <p>I have a log parser query that gets the top 200 uris, however I don't want any cs-uri-stem entries that have a dot (.) in them. </p>
  
  <p>This is as close as I've come, but it seems like the wildcards are not acting as I expected:</p>
  
  <pre><code>"SELECT TOP 200 cs-uri-stem, COUNT(*) AS Total INTO \Top200URIs_NoDots.csv 
  FROM "\2015-01\U*.log" 
  GROUP BY cs-uri-stem 
  HAVING cs-uri-stem NOT LIKE '%.%'
  ORDER BY Total DESC"
  </code></pre>
  
  <p>When I run this I get an Error:</p>
  
  <pre><code>... HAVING cs-uri-stem NOT LIKE ''...
  Error: Syntax Error: &lt;having-clause&gt;: not a valid &lt;expression&gt;
  </code></pre>
  
  <p>Why is it ignoring the '%'s and everything between?</p>