>>>>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

That was my memory not serving me right, I remembered 'transaction'. Semicolons were the typos then. I didn't go back to original syntax. BTW formatting that code for UT doesn't require semicolons, it was clear that it is T-SQL.
Cetin