search records with NULL

[ikim2000]

I'm trying to delete records with a column that has null value and I can't get the correct syntax. I tried the code below, but end up with an error.
------------------------------------------------
DELETE FROM tblOrder WHERE OrderDate = Null
------------------------------------------------
What would be the correct code?

Thanks,
Ik

 

[clapag22]

DELETE FROM tblOrder WHERE OrderDate <b>IS</b> Null

 

[clapag22]

Try that again:

DELETE FROM tblOrder WHERE OrderDate IS Null