TEXT TO lcSQL NOSHOW PRETEXT 1 Create sql view lv_cust as Select * from customer where cust_id = ?cCust_ID ENDTEXT *!* A new pretext option in VFP9 eliminates this next step lcSQL = strtran(lcSQL, CHR(13) + CHR(10), [ ]) &lcSQL cCust_ID = [BERG'S] USE lv_CustYou can use TEXTMERGE in the TEXT TO as well if you need to include VFP functions, variable values, etc.