lcWhereClause = "" if not empty(lcLastName) && hypothetical variable lcWhereClause = lcWhereClause + " lastName = lcLastName" endif if not empty(lcZip) lcWhereClause = lcWhereClause + " zipcode = lcZip" endif if not empty(lcWhereClause) lcWhereClause = "where " + lcWhereClause endif select * from customers &lcWhereClause into cursor tempHTH,