George (and Mike and Jim)...

Thanks for responding. In the situation I described, it is highly unlikely that the # of scenarios will go beyond 4...so I can certainly live with a single stored proc that has 4 different SQL statements and some IF statements for which one to run.

My second question, a more general one, is this - if I programatically build a SQL SELECT string statement in a stored proc and then call it with the EXECUTE function, am I truly losing performance (as opposed to a more 'constant' SQL Select statement in a stored proc)? Basically, I'm trying to get a handle on which practices and techniques will sacrifice speed.

Thanks,
Kevin