Yes, you are right. I am so used to doing it in other ways, so I have not studied the new SQL syntax additions. I planned to wait for the release of VFP9 and spend a few weeks updating my knowledge.

>>You're welcome. An enhanced APPEND FROM with something like FIELDS myfunction() AS field1 has been on my wish list for years. But I have found that cursors are extremely fast, so I have learnt to live without it.
>
>Tore,
>
>Starting with VFP8 we've INSERT INTO...SELECT FROM which can do exactly what you're looking for.