DavE E (3/24/2009)
I understand all this but why doesn't Microsoft make everyones life easier and make it work as everyone expectsi.e. NULL does equal NULL
So we can use col2 = NULL or col2 != null instead of IS NULL or IS NOT NULL.
It would lead to so many less bugs
Apart from the issue of following ANSI SQL standards, when I add a clause "WHERE col1=col2" I want to be sure that the two columns contain identical data, not just that they both happen to have been left blank, or generated by a non-matched item in an outer join.