> With a SP as your detail set, there is no cursor, so there can't
> be a WHERE
> clause.

?? I use WHERE clauses on SSPs all the time. There can be, and it works
from the server, but you must be referring to something else.
Alan