Thanks guys. Both suggestions are working.

-Mike

Thanks for the reply. But it still leaves me scratching my head for a way to code around this.

I changed the code around to use a table object but...

Thanks for the quick reply. I'm in 2005 - I'll give the TRY/CATCH a go.

-Mike

I'm seeing the light on Tally tables. Especially the solution Hugo provided for David Jackson. This a great article and has given me reason to re-think and re-visit...

Thanks for the advice. I'll take a look.

You know how it is...you find something that works for you and then forget about it. But if there's a better way...

If your list of doctors is being passed into the stored procedure as a delimited string then you can write a table-valued function to parse the string and return it...