Buddy, NULLs work in DEL DUP USING, but only if you have EQNULL ON. --- "Walker, Buddy" <[EMAIL PROTECTED]> wrote: > 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 > >
Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
