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.