operator NOT does not invert the result of a NULL comparison
<p>Please see these two statements:</p>

<pre><code>select 'true'  where (1 = NULL) ; 

select 'true' where not (1 = NULL) ;
</code></pre>

<p><strong>Both</strong> (!) of them return empty! </p>

<p>So that means that the expressions <code>(1=NULL)</code> and <code>not (1=NULL)</code> both return false! But how can that be? I thought the operator <code>NOT(expression)</code> will invert the result of the expression ?</p>

<p>According to Microsoft: <em>"Comparing NULL to a non-NULL value always results in FALSE."</em></p>

<p>OK, but that would mean that the operator <code>NOT</code>must invert the result. But why does it do this not then? </p>

<p><a href="https://msdn.microsoft.com/en-us/library/ms188074.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms188074.aspx</a></p>

<p>EDIT: I posted the wrong article. 
My quote above is from this article: <a href="https://msdn.microsoft.com/en-us/library/ms175118.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms175118.aspx</a></p>

<p>It seems this article has an error, as stated below in the answers and comments.</p>