Thanks for code and explanation. I guess i could put the conditions in a separate table and use the data to create the parameters required for this stored procedure.

Edited by...

Thanks for that, seems less hassle to do it this way.

Dinesh

(As a side effect to the article), thanks for making me aware of the CREATE SCHEMA AUTHORIZATION command.

raj