Not sure what this does to the optimizer but:

where
( Co_name=:Co_Name OR :Co_Name is NULL ) and
( town=:town OR :town is NULL ) and
( Num_Employees=:Num_Employees OR :Num_Employees is NULL )

should work (assuming :Num_Employees is a parameter to a stored procedure).

-steve

tickerboo2002 wrote:

>
> Users of my app will be able to fill in parameters that go into a
> query to search for rows. The query has fixed parameters in the where
> clause: i.e.
>
> where
> Co_name=:Co_Name and
> town=:town and
> Num_Employees=:Num_Employees
> etc
>
> Let's say the user is not interested in Num_Employees, is it possilble
> to set the parameter so that clause is ignored?
>
> I assume for varchar entries I can just set Col=* (or is it %?)
>
> Thanks
>
> David
>
>