> I have a question about the double single quotes. Won't the program think that is a break and put the second part of the string into the next field?

Which program, VFP or T-SQL? In VFP you can use double quotes or square brackets as a string literal delimiter to avoid such problem. T-SQL treats double single quote as a single one within a string literal.

>
>On the text merge code, I put the code you gave below into my program, and my veriable lcSqlStr remained a empty string after moving through that code. What is the 'Pretext 7' do? Should I take it out?

What VFP version you run it in? I'm not sure it'll work in VFP6. For 'Pretext' description see help file for TEXT..ENDTEXT command. Also, the code I provided is just an example and may not work for you 'as is'. You may have to adjust it to your requirements.