>i need to replace at my table sequential number as
>
>record 1 at field (no)=1
>record 2 at field (no)=2
>.
>.
>.
>.
>.
>. at field (no) =99999999
If you don't have deleted records, you might make sure of that by doing a PACK, you can then do:
REPLACE ALL No WITH RECNO()