title: SQL Server: not like (<>) hides null values
body: <p>I have this query:</p>
  
  <pre><code>select * from Table1 where Table1.Name &lt;&gt; 'John'
  </code></pre>
  
  <p>It returns everything that has not Name = 'John' but it doesn't return null values as expected. How I can solve this?</p>