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