I agree that it's smell like a bug, but it's been there from a long time.
I would do the following:
SELECT OriginalTable
SCAN FOR Upper(Alltrim(Country)) = "FINLAND"
INSERT INTO DestinationTable;
(FieldA, FieldB FieldC);
VALUES (OriginalTable.FieldA, OriginalTable.FieldB, OriginalTable.FieldC)
DELETE
ENDSCAN
HTH
>Isn't it still wrong though!? Shouldn't it supposed or meant to append ONLY 'Finland' and not others!?!?!?!?!?
>
>Dear "Beats-me" professionals, can you please please at least code a little sample. I am not good (if not at all) with SCAN...ENDSCAN. I just want to copy record(s) to other tables and then delete 'em (SET DELETED ON is on) and then go to the next record (GO TOP or LOCATE since the previous record(s) is already deleted). Man, I am still paining my stomach with the program seeming endless with buch of old-style programming/coding. If you don't mind, I really like to post (or even email) the coding I have done so far so we can look at it over together (it was supposed to be due today, but I have no idea if this will ever be due by Friday!). So far, it has about 150 lines of codes.