Valorize parameter to get alla records

Hi to all!
I'm executing a query from a my application using paramters for the WHERE clausole.

It's possibile force the value of one parameters to work like a jolly (*) and get alla the records?
In this way i can use the same query for a selective selectione or an "all recorsd" selection

example:

Select name from mytable where name = :MyName;

Thanks and sorry for may very bad english. Received on Wed Aug 22 2007 - 01:47:43 CDT