What abt Dynamic Where condition??

Is there any facility to create dynamic where condition for queries. i.e. Let's say, user will pass couple of filter condition for few fields(may vary in number and pattern) and we need to filter based on that condition... something like creating dynamic query in SQL.

If not, is there any way to achive this kind of functionality.

Thanks.

Gaurang