for i= month12004 to month1212004 replace name2 with "wwwww" replace name3 with "tttt" replace name4 with "sssss" <pre> any idea, yhanks. >Usually, the best alternative is to have all the data, for different months and years, in a single table in the first place - precisely to make it easier to manipulate the data. > >You can write a small program to do all the REPLACEs, but then you will have the same problem over and over again, for DELETE, SELECT, etc., and under different conditions. > >>hi all, >>i try to do this code under,any new way.. >><pre> >>USE month12004 >>LOCATE FOR no =1231 >>replace nam2 WITH "صالح" >>replace nam3 WITH "احمد" >>replace nam4 WITH "المحمود" >> >>USE month22004 >>LOCATE FOR no =1231 >>replace nam2 WITH "صالح" >>replace nam3 WITH "احمد" >>replace nam4 WITH "المحمود" >> >>USE month32004 >>LOCATE FOR no =1231 >>replace nam2 WITH "صالح" >>replace nam3 WITH "احمد" >>replace nam4 WITH "المحمود" >> >>USE month42004 >>LOCATE FOR no =1231 >>replace nam2 WITH "صالح" >>replace nam3 WITH "احمد" >>replace nam4 WITH "المحمود" >>. >>. >>. >>USE month122004 >>LOCATE FOR no =1231 >>replace nam2 WITH "صالح" >>replace nam3 WITH "احمد" >>replace nam4 WITH "المحمود" >> >>>>thanks