hi,
thank you very much,fantastic
save time and code.
i try as under it works but bad way.

USE bill_value
GO top
m.no=1

DO WHILE .t. AND !EOF()
replace no WITH m.no
skip
m.no=m.no+1
IF EOF()
EXIT
ENDIF
enddo
brow

thanks

>>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()
>