Buddy I was thinking along the same line but I only want to delete the row where compdate fails Can I use your sample with a where clause....where compdate fails?
Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Walker, Buddy Sent: Friday, April 01, 2005 10:51 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: delete rows Bill Can't remember if this worked in 6.1 or not. DEL DUP FROM tableName USING reqdate,section,range,plot,compdate Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Sent: Friday, April 01, 2005 10:33 AM To: RBG7-L Mailing List Subject: [RBG7-L] - delete rows I have a table that can have duplicate rows (Dos 6.1) Is there a way I can delete dup rows based on certain fields? example 5 fields > reqdate, section, range, plot, compdate I want to delete the row where reqdate,section,range,plot are equal and compdate fails? Thanks Bill
