For quite some time we have been using a particular syntax which has worked quite well for us in determining NULL matches.

In our where clause we would use...

Where ISNULL(column,'') <> ''  -- this will match all non-NULL columns

In the article, you mention that ISNULL() is not preferred to use. Can you explain why?