You can SELECT ... DISTINCT, or SELECT ... GROUP BY, and then copy back to the original table.
HTH, Hilmar.
>Hi all
>
>I have mytable.dbf with an index on empno.
>
>recn() empno
>1 10000
>2 10000
>3 10000
>4 10000
>5 20000
>6 20000
>7 30000
>8 30000
>9 30000
>10 30000
>
>to get mytable after deleting the records number 2,3,4,6,8,9,10
>
>and to keep only
>
>recn() empno
>1 10000
>5 20000
>7 30000
>
>Please help in coding
>Thanks
>PP
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
