I take it we are still talking VFP 7 here Mike


>TEXTMERGE and TEXT - ENDTEXT also allows output to a memvar.
>
>For example: You need to build a long sql statement into a string for remote database access. Instead of
>
>

>lFld1 = "SMITH"
>lFld2 = "JOHN"
>SqlStr = "SELECT *"
>SqlStr = SqlStr + " From YourTable"
>SqlStr = SqlStr + " Where LastName = '" + lFld1 + "'"
>SqlStr = SqlStr + " AND FirstName = '" + lFld2 + "'"
>SqlStr = SqlStr + " AND ActiveCustomer = 'Y'"
>

>
>You can
>

>lFld1 = "SMITH"
>lFld2 = "JOHN"
>TEXT to SqlStr TEXTMERGE NOSHOW
>SELECT *
> FROM YourTable
> WHERE LastName = '<<lFld1>>'
>   AND FirstName = '<<lFld2>>'
>   AND ActiveCustomer = 'Y'
>ENDTEXT
>SqlStr = STRTRAN(SqlStr,CHR(13)+chr(10),"")
>

>
>Wish there was a clean way to prevent the CRLF without using a STRTRAN or the // prefix with Textmerge.