Why can't I delete this?

[golyg]

Hi all, I have an INSERT statement that enters a bunch of new rows, then I would like to DELETE all rows where id = 'NULL'
I am using the following command(s):
DELETE FROM t_devices WHERE id like 'NULL';
as well as
DELETE FROM t_devices WHERE id = 'NULL';

neither are working but if I do this:
DELETE FROM t_devices WHERE id <> 'NULL', all other records are being deleted.

any suggestions?

thanks,

 

[mwolf00]

DELETE FROM t_devices WHERE id IS NULL -- Just trying to help...
<--- This is a wolf? We need a new icon.......
mikewolf@tst-us.com

 

[golyg]

thanks, that did the trick....