CLOSE ALL USE interviewed INDEX ON MOD(fixed_line,1000000) && For Numeric field INDEX ON SUBSTR(fixed_line,2) && For Character field SELECT 0 USE source SET RELATION TO fixed_line INTO interviewed REPLACE ALL flag1 WITH interviewed.flag1 FOR FOUND('interviewed')>hi all,
>CLOSE all > >USE INTERVIEWED in 0 >INDEX on fixed_line TO ll >USE source in 0 >INDEX on fixed_line TO hh > > > >replace IN source ; > FOR fixed_line==LOOKUP(INTERVIEWED.fixed_line,fixed_line,INTERVIEWED.fixed_line) AND NOT EOF('INTERVIEWED') ; > flag1 with INTERVIEWED.flag1 >>thanks.