>Hi all,
>
>I can do some benchmarks on this but if there is a general idea as to which one is faster in this scenario:
>
>

>* scene1:
>select fktable
>go top
>scan while !eof()
>  replace fktable.fkdata1 with iif(seek(fktable.fkid, 'pktable', 'pkid'), pktable.pkdata1, "")
>  replace fktable.fkdata2 with iif(seek(fktable.fkid, 'pktable', 'pkid'), pktable.pkdata2, "")
>endscan
>
>* scene2
>select fktable
>go top
>scan while !eof()
>  seek(fktable.fkid, 'pktable', 'pkid')
>  replace fktable.fkdata1 with iif(eof('pktable'), "", pktable.pkdata1)
>  replace fktable.fkdata2 with iif(eof('pktable'), "", pktable.pkdata2)
>endscan
>

* scene3:

select fktable
replace all fkdata1 with ;
  iif(seek(fktable.fkid, 'pktable', 'pkid'), pktable.pkdata1, ""), ;
  fkdata2 with pktable.pkdata2

Cetin