Hey Dan,

My computer keeps locking up before I can get a reply to you out. Here's the important stuff in reply to you 2nd to last response. I think you're right about it seeing almost everything empty().


The index order for Argentina in browse is :
011549
01154351
01154341
01154261
01154223
01154221
0115411
01154

I hadn’t been seeing the replacements while I was running your code within my application. Split it out into its own little program and on a 19000 record table it made 21000 replacements. Then I reran the program with all the fields already filled in on the 1st pass (so it shouldn’t make any replacements) and it still made 18059 replacements. Seems like it’s ignoring the for statement for some reason.

But I also tried running the replace within an if statement and got the same data.

DO WHILE NOT EOF()
IF NOT Empty(dest)
REPLACE…..
ENDIF
ENDDO