Yeah, I wish I could do something like that, but as an example using the status values, the input string could be something like A,AN,N,A1,N1  or it could be A,AN in...

Thanks for the link, but in essence, we already know dynamic sql isn't the answer.  The current dynamic sql is too long to reasonably maintain, somewhat poorly structured and unless there...

Ok, I see the error of my ways now...  What I've been trying to do is what is being suggest, I've just been using the wrong syntax.  Newbie mistake I...

Thanks for the reply Nicolas.  But, I think you're just confirming what I was afraid of.  I have no problem making it work if the number of params is known. ...