Taggs, Try    SELECT * FROM TableName WHERE row3 is null If I am not mistaken, ANSI NULLS would prevent   WHERE row3 = null from returning true, since ANSI NULLs are treated as Unknown values.  If we don't know the value, we can't say it's equal to something else.. even another unknown. Cheers, ~ihnm