title: Is this the proper way to do boolean test in SQL?
body: <p>Assume active is a &quot;boolean field&quot; (tiny int, with 0 or 1)</p>
  <pre><code>-- Find all active users
  select * from users where active 
  
  -- Find all inactive users
  select * from users where NOT active 
  </code></pre>
  <p>In words, can the &quot;NOT&quot; operator be applied directly on the boolean field?</p>