title: How can query be optimized?
body: <p>I have a simple select query on a table, but with different values in LIKE operator. Query is as follows:</p>
  
  <pre><code>SELECT *
  FROM BatchServices.dbo.TaskLog
  WHERE EntryTime BETWEEN '20190407' AND '20190408' AND
        TaskGroup LIKE '%CSR%' AND
        (LogText LIKE '%error%' OR LogText LIKE '%fail%')
  </code></pre>
  
  <p>This above query is fine and returning me the expected results but I don't want to have multiple LIKE in a query, so I have already tried something like </p>
  
  <pre><code>SELECT *
  from BatchServices.dbo.TaskLog
  WHERE taskgroup = 'csr' AND
        LogText IN ( '%error%','%fail%') AND 
        EntryTime&gt;'2019-04-07'
  ORDER BY EntryTime ASC
  </code></pre>
  
  <p>This query is not giving me any results.
  I am expecting a query which looks smarter than the one I have which returns result. Any help?</p>