hi,
thank you,
can you help me to add it to code

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
>See if Thomas' ideas help you:
>
>Re: What is the best index expression? Message #1006091
>
>
>>hi all,
>>
>>i try to compare between 2 tables via field(fixed_line) at 2 tables
>>
>>but source.dbf have fixed_line as 7 numbers, and another table have fixed_line as 6 numbers,
>>i need to to begin from second number from source.dbf
>>
>>as 8524163 begin form 524163.
>>

>>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.