Thanks gail for the reply..let me go through the article

I am planning to pass the condition as a table value parameter, each row has a different condition

Chk the attached picture below

I am attaching the search diagram where i have to use this procedure