Simon,

If another work area is currently selected besides znaf2 and that work area is at EOF, the replace will not happen.

PF

>Dear Jim
>
>Thanks for replying I'm your student from Appdev, According to your lessons the following should work...
>
>
>SELECT *,SPACE(8) as nafseq2 from znaf INTO TABLE datax\znaf2
>
>seq=8950
>SCAN
>seq=seq+1
>replace znaf2.nafseq2 WITH ALLTRIM(znaf2.nafseq) IN znaf2
>replace znaf2.nafseq WITH STR(seq,8) IN znaf2
>ENDSCAN