>Dear Experts
>
>Table1 has 10 numeric fields named Filed1,Field2,Field3 and so on to Field10.
>The code=1301002 is located in some fields.
>I want to replace it with 1501002,
>
>How to findout code=1301002 from whole table?
>Table1 has no index order set.
>
>Please help
FOR mycount = 1 TO 10
curfield = "Field"+TRANSFORM(m.mycount)
REPLACE &curfield WITH 1501002 FOR &curfield = 1301002 ALL IN Table1
NEXT
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst