Jerry,

Seems you want to have a static SQL statment that produces different results caused by the parameters.

One method is to construct the WHERE clause dynamicly.

cWhere= somewhere expression
SELECT * FROM mytable WHERE &cWhere

In local views you can use SELECT * FROM mytable WHERE &?cWhere, but be sure the cWhere variable is available whenever using REQUERY.

Regards,

Walter,




>I have a table with these fields; cdesc, nprice.
>
>I can SELECT * FROM mytable WHERE cdesc = "". This will produce a cursor with all records in the results, which is what I want.
>
>How can I do the same for the numeric field?
>
>SELECT * FROM mytable WHERE cdesc = "" AND nprice = 0 only brings up the records with 0 in nprice. I want all the records. Then I want the user to narrow the search like this;
>SELECT * FROM mytable WHERE cdesc = cvar AND nprice = nvar
>
>How can I do this?
>
>Thanks,