Select Mytable Set Order To ManifestNum lcManifestNum = Null SCAN IF lcManifestNum = Mytable.ManifestNum Delete ELSE lcManifestNum = Mytable.ManifestNum ENDIF ENDSCANThis code assumes that you have index on manifest number and you want to keep the first of the dup records.