You can start with

SELECT DISTINCT Cust_id FROM MyCust.dbf

>I have a table MyCust.dbf with the records:
>
>

>Cust_id
>-------
>00001
>00001
>00001
>00002
>00003
>00002
>

>
>what is the shorter way to delete all those double entries, so each ID only has one records?
>
>thanks for the help
>
>Jerry