That's exactly what REPLACE I posted does.
>I do not need following answer
>replace qty with 1 for code = '1401'
>
>I wnat to use loop or scan to replace qty with 1 agains all codes begins with '1401'
>
>It should apply on all codes in table1
>
>Please help again
--sb--