title: How to perform bitwise operations arithmetic in MS-ACCESS
body: <p>Inside MSACCESS I want to use relatively simple bitwise operations in <code>WHERE</code> clause of queries such as this:</p>
  
  <pre><code>SELECT *
  FROM Table1
  WHERE Column1 (some operator) 8 = 0
  </code></pre>
  
  <p>This would:</p>
  
  <ul>
  <li>Return rows where <code>Column1</code> does not have its 4th bit set e.g. 0, 1, 2, ..., 7 (all have their 4th bit clear) and 16 (it is 00010000b)</li>
  <li>Exclude rows where <code>Column1</code> is 8, 9, 10, ..., 15 etc.</li>
  </ul>
  
  <p>PS: are bitwise operators different from boolean operations?</p>