Delete <NULL> fields

[JohnKIT05]

Few of my databases has records of <Null> data in the fieldnames. I tried several ways of writing a code to delete those records but it will say '0 records affected'.

Here is an example of my code to delete the records with the <NULL> data:

USE PurchTransf
DELETE FROM Whse2Data
WHERE UnitsMTD = Null and AUGunits = Null and
DECunits = Null and FEBunits = Null

John

 

[Sheco]

try IS instead of =

 

[bassguy]

hi,
null relationships are "is" null not "=" null also unless you want all four columns to be null you need or statements

try

DELETE FROM Whse2Data
WHERE UnitsMTD is Null or AUGunits is Null or
DECunits is Null or FEBunits is Null

HTH

Bassguy

 

[JohnKIT05]

Hey bassguy and Sheco,

You both are right. I happens to find the answer while I was searching the index in the help of the SQL Analyzer when you both replied. That was the answer.

Thanks,
John

Hey bassguy I play guitar too. Keep rockin!!!

 

[bassguy]

at least you didn't ask what kind of bass i fish

bassguy