>hi all,
>
>i have table(test) with 500000 records,
>
>i need to divide my table (test) to 5 tables evrey table have 100000 records
>with names as test1....test5.
>
>thanks.
>
>m.qasem

use test
copy to test1 for between(recno(),1,100000)
copy to test2 for between(recno(),100001,200000)
copy to test3 for between(recno(),200001,300000)
copy to test4 for between(recno(),300001,400000)
copy to test5 for between(recno(),400001,500000)

Cetin