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.