Sign up ×

Currently I'm just trying to delete objects with the Name column being Null from a temp table with the following...

delete from #PulledData
where #PulledData.Name0 = NULL

I've also tried = 'NULL', = '%NULL%' etc. but nothing seems to work. I'd appreciate some help on the matter.

share|improve this question

2 Answers 2

up vote 5 down vote accepted
delete from #PulledData where #PulledData.Name0 IS NULL
share|improve this answer
Thank you, silly mistake on my part. –  Hoser Jul 17 '12 at 16:21

You need to use IS NULL.

This could be fixed another way to use the = syntax, but that option is going away soon.

share|improve this answer

Your Answer


