title: Not Equal does not work in SQL Query
body: <p><img src="https://i.stack.imgur.com/72ltJ.gif" alt="enter image description here"></p>
  
  <p>I am trying to use the "Not Equal" command in Sql but it does not seem to be working. I want to get the total count when all the 3 fields (status1, status2 and status3) are not equal to Yes. For some reason I am getting 0 records.</p>
  
  <pre><code>SELECT
      COUNT(ID) from [maintable]
  WHERE 
      status1 &lt;&gt; 'YES'
      and status2 &lt;&gt; 'YES'
      and status3 &lt;&gt; 'YES'
  </code></pre>
  
  <p>The above query does not generate any results. What am i doing wrong here? Thanks </p>