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