>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
go top
i = 0
do while not eof()
copy to ("test" + trans(i)) next 100000
skip
i = i + 1
enddo
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)