title: SQL: problems with like and NOT LIKE
body: <p>i have this statement in access:</p>
  
  <pre><code>SELECT *
  FROM accountsnew
  WHERE [Panels] not like '*IT_OXYC,*' and [Panels] not like '*OXY_SN,*' and [Panels] not like '*OXY_S,*' and [Panels] not like '*OXY_N,*' and [Panels] like '*OXYC_SNEG,*' or [Panels] like '*OXYC_PNEG,*';
  </code></pre>
  
  <p>for some reason it is not returning the proper dataset. when i look more deeply at the data returned, using excel, i see that what it returned in fact DID contain <code>IT_OXYC,</code> and some other parameters.</p>
  
  <p>is there something wrong with my statement?</p>
  
  <p>i am trying to get all records which do not have <code>IT_OXYC,</code> <code>OXY_SN</code> , <code>OXY_S,</code> <code>etc</code>... and DO have either <code>OXYC_SNEG,</code> or <code>OXYC_PNEG,</code></p>