>Hi Mike,
>
>Certainly I am ready to remove ; at the end of lines, however I did not notice anything on the end of lines but character(13) am I missing something here?
>

I used TEXT...ENDTEXT to build SQL, but I add ; at the end of the lines so I can execute it in a VFP prg or command window.

They have to be chopped off for SQL Server, and are optional for VFP.