>At this point, what do you gain by trying to push this into a stored proc? I see no benefit. You might as well just execute the ad-hoc query directly instead of hiding it within the stored proc.
>
>-Mike

I guess I'm confused... I am sending a list (that could have one, but will more than likely have several keys) to this sp to bring back a representation of the data to vfp. I am allowing the programmer to limit everything (Select list, where clause, group by clause, etc) so I might limit network traffic - that's why the select will (may) never be the same.

How could I create the same functionality in one select?