>>>That syntax wouldn't work in VFP so you misguided me. InSQL server there isn't a limit. In VFP, who cares, only could be of academic interest.
>>
>>
>>The syntax wouldn't work in SQL either, with all the semi-colon continuation lines added.
>
>Yes, in my original reply I told Naomi about the typos (not only semicolon, keyword used as tablename without brackets as I remember).
>Cetin

Transact table name doesn't give us problems. The exact query worked fine in SQL Server though I did add ; when I was formatting this code for UT