Deleting a row with blank fields 1

[jensies]

Hi,

I have a table in which all of the fields can be null. I need to delete a row but cannot seem to get the correct way of setting it up to work.

My query is
DELETE FROM configTable
WHERE var1 = '6' AND var2 = null AND var3 = null and var4 = null

Would anyone know how to do this?

Thanks
Jenny

 

[rt63]

Instead of = null , use is nul

DELETE FROM configTable
WHERE var1 = '6' AND var2 is null AND var3 is null and var4 is null

RT

 

[jensies]

You are a total star!

Thanks!