>I want to delete all the records in a table that have the same manifest number but keep the one record of it in the table. How would I do this?
>
>Tyler

Select Mytable
Set Order To ManifestNum
lcManifestNum = Null
SCAN
    IF lcManifestNum = Mytable.ManifestNum
        Delete
    ELSE
        lcManifestNum = Mytable.ManifestNum
    ENDIF
ENDSCAN

This code assumes that you have index on manifest number and you want to keep the first of the dup records.