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.