>Interesting that no error is generated during compilation time because of macro substitutions.
>

VFP don't compile every line with a macro; it put the line "as is" into the object code.

>>
>>I knew it was one of those "Can't see the wood for the trees" occasions.
>>
>>I've scrutinized each line and STILL didn't spot it. I know how it happened. I copied the select clause from a similar SQL, and deleted the last line for this, but forgot the comma.
>>
>>Well done you eagle-eyed people.
>>
>>>You have extra comma after the last field in the list (before FROM).
>>>