yes, that is actually our Plan B haha.. But I wanted to avoid this, because we need to create a StoreProcedure for each filter, I was though about to create...

Hi Atif,

I need to find a different solution Dynamic SQL is not what I want, I want another kind of solution even if I need to create a filter table...

I see, thank you for your responses, I appreciate the effort you made, but unfortunately the Database is already created =(.. so they are doing this kind of filters though...

Hi Grant,

But the customers want to change this as soon as light speed, If I send this thought parameters I will need to change my Bussiness layer each time a...

Hi,

Thank you both for your quick response. the scenario is this:

I have customers, these customers has produces and a lot more of information, these customers also has contacts.

Sometimes (almost always)...