In SQL Server, why is it that NULL does not equal empty string AND doesn't not equal empty string? -


This is not clearly a line back ...

  of 1 Select where zero = ''   

but why does not it also return one line?

  Select 1 where zero & lt; & Gt; ''   

Where can both of them be "wrong"?

" How can both of those WHERE be" false "? " < / P>

Not so! The answer is not "true" either! The answer is "we do not know"

Think of NULL which you do not know yet

Can you bet that this is '' is?

Can you bet that this is not '' ?

So, you still do not know that you do not have any information yet. Therefore the answer to both questions is not false, but I do not know , e.g. In NULL SQL

Comments