>>With "SELECT * FROM customer WHERE customer.lastname = ?vp_lastname", it's easy enough to pass "" as the parameter and get all customers, but what about a date(customer.lastdate) or integer(customer.custid)?
>
>You could have either a compound WHERE, or you could have a different view for each type of query. CustomersByLastName, ByDate, ByCustID, etc.

Okay, I hate to sound dense, but can you give me an example of the compound WHERE clause? It sounds like the answer I want, but can't quite see.

SELECT * FROM customers WHERE
custid gives all records OR custid gives one record