>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'" >>
>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),"") >>