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