ISNULL

This tip comes from my friend Laura the uber DBA. If you’re testing a value for being NULL or being an empty string, do both at the same time with this handy dandy magic:

WHERE ISNULL(fieldname, '') != ''