SP and dynamic where clause.

Posted in 1996

M Ferris — Mon, 26 Aug 1996 16:54:01 -0500 — source: Informix-list mailing list archive (1991-1998)

I don't think the following can be done, but I thought I would ask anyway. I have a report(s) that a user calls with 4 retrieval parameters. The user can select the retrieval parameters in any fashion or combination. I have 4, and by my reckoning, I have 15 unique combinations. This means I have 15 different where clauses. Is there any way to pass the entire where clause (not just the variable) into a stored proc? (I just "upgraded " to MS IE 3.0 which does not support news reading, so if possible, please respond via email.) Thanks, Matt Ferris