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,