SQL2000-Passing in a where clause?

I am trying to pass in a ‘where’ clause to a stored procedure. This ‘where’ clause will be different every time. I am trying to hide my logic in the stored procedure rather than pass back a record set and then use my logic on the results. I cannot get SQL to recognize the input parameter as part of the stored procedure. Is this even possible? If so what is the trick? Thanks!!