Tracy,

just run this code and open it in the VFP8 view designer and look at the SQL code

>

>*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 )

Not exaclty what you're trying to do...

Walter,