title: <> operator in SQL
body: <p>I have a table like this</p>
  
  <pre><code>ID   Name    IsDeleted
  1    Yogesh  Null
  2    Goldy   1
  </code></pre>
  
  <p>Now when I run this query</p>
  
  <pre><code>select  * 
  from tableName 
  where IsDeleted &lt;&gt; 1
  </code></pre>
  
  <p>I should get <code>ID 1</code> record, But I am not getting it,</p>
  
  <p>But when I run this </p>
  
  <pre><code>select  * 
  from tableName 
  where IsDeleted is null
  </code></pre>
  
  <p>I get <code>ID 1</code> record,</p>
  
  <p>Why am I facing this behavior ??
  Isn't <code>NULL &lt;&gt; 1</code> is a true statement in SQL ??</p>
  
  <p><code>IsDeleted</code> is a <code>bit</code> type field with <code>Allow Null true</code></p>