Deleting NULL results 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.
delete from #PulledData where #PulledData.Name0 IS NULL