It does work that way. You must have another problem.

Some things to keep in mind:

o country must be a field in the table you are appending into.
o there has to be some records in the source table with 'Finland'
o there is wierdness with appending deleted records. Basically, even if the record is deleted in the source table, its probably gonna show up in the target table.

>In the help (both "F1" and book) for APPEND FROM, it states in the example that APPEND FROM customer FOR country = 'Finland' would mean that FP supposed to look in the customer.country and append ONLY 'Finland' from customer into the backup, is that correct? How come it does not really work that way in the real world? Are there another command or better way of doing this? INSERT - SQL will not work, since I am NOT using any form (SCATTER/GATHER). Any idea or what to do about the old APPEND FROM command?