I agree, each approach can serve a different purpose and different needs. You can build the query dynamically at the BL, you can use dynamic SQL, *or* you can use...

The two conditions in the article were just examples of the wealth of criteria there are for the same query. They were two separate conditions which were not meant to...

Wow. It's been 3 years and still there is a lot of activity on this post. Thank you all very much for your replies.

Adding to what I said then,...

When I was assigned this task, I first thought of a similar approach. But when you have over 10 fields to filter by this can be rather big. You also...

You are right. My point, though, was to show how an operator-driven query could be performed, actually neglecting any performance issues. There are some cases, for example, a custom query...