Interesting that no error is generated during compilation time because of macro substitutions.
>
>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).
>>
--sb--