Procedure with multiple where clauses

Hey,

I'm searching for a solution for the next problem :

We want to create a 'dynamic procedure' that could be used for multiple search operations.

So we give multiple paramaters to the procedure -- not every parameter will be used -- and in the procedure we
have a select with a where clause that is created from the parameters that are filled in ...

Is there a solution ?

kind reg.

Wesley Received on Mon Mar 18 2002 - 09:31:55 CET