>*Populate cWhere first via some type of user input >cWhere="Testtable.ca_sysnum = ( 1 )" >CREATE SQL VIEW VFP8View AS ; >SELECT *; > FROM ; > testtable; > WHERE &cWhere >You'll see that the where clause is now hardcoded as: WHERE Testtable.ca_sysnum = ( 1 )