Hello again Cindy.

I had some vague recollection that this was possible, but when I had started this SQL Server conversion project I couldn't think of what to search on in help. This project is going to go much faster because:
- coding of the strings will be much faster, since there will be far fewer changes to the SQL statements
- the code is far easier to understand while debugging
- pasting the statement into the SQL Server query analyzer now has the proper multi-line formatting

>Do you need to use the TextMerge keyword? Right click on the whole code including the lnCustID = 1 and execute.

>lnCustID = 1
>Text To lcSQL TextMerge NoShow
>Select
>  Customers.*
>From
>  Customers
>Where
>  ID = <<lnCustID>>
>Order By
>  Name
>EndText
>
>*-- _ClipText = lnCustID, paste into SSMS