Syntax for deleting record where a column has no value

[TomBarrand]

I would like to delete some records from a database that has blank values in. Below is an example of how the table might look.

partNo description buyEach sellEach qty
0 0 0
12345 computer 800 1200 2

What is the syntax?

thanks

Tom

 

[tlbroadbent]

Delete table1 Where PartNo Is Null or PartNo='' Terry

X-) "Life would be easier if I had the source code." -Anonymous