Just to throw another routine into the mix....

http://www.craigberntson.com/Articles/kb006.htm

>I have this table with almost 2,000 record and, I need to re-orde and assign a sequencial number but I need to know if I can do it with some routine not manually. And after that how I make VFoxPro auto increment.
>
>V/R
>R. De Jesus