title: QUERY WHERE BOTH FIELDS DON'T CONTAIN SOMETHING
body: <p>I want to query data where BOTH the phone1 and phone2 codes don't contain the word 'mobile'.  Tried AND and OR statements but its not working when 'MOBILE' exists in one of the fields. </p>
  
  <pre><code>    select ORDCON.* from PL00.dbo.ordhdr inner join PL00.dbo.ordhdrx on ordhdrx.ORDER_NO = ordhdr.ORDER_NO
                                 INNER JOIN PL00.dbo.schedule on schedule.ID_VAL = ordhdr.ORDER_NO
                                left outer join PL00.dbo.ordcon on ordcon.ORDER_NO = ordhdr.ORDER_NO
  where ordhdr.RSPNS_CODE = 'TXTB4'
  and (schedule.[DATE] &gt;= CONVERT(varchar(10), getdate(), 101)) 
  AND (NOT ORDCON.PHONE1CODE = 'MOBILE' 
  OR NOT ORDCON.PHONE2 = 'MOBILE')
  </code></pre>