If it's SQL 2000 than you would be better off using XML. See
Re: Selecting records based on cursor values Message #
690890.
>I have a SP where a select a group of records based upon an ID passed. The ID is a string, max size is Character 8.
>
>For a single id this works.
>select fk_name where cattorneyid = @firmid
>
>This also works for a single id.
>select fk_name where cattorneyid in (@firmid)
>
>These are both run using exec Attorney_list '000449'
>
>However, I cannot pass a string containing more than 1 ID.
>
>exec Attorney_list '000449,105690'
>OR
>exec Attorney_list "'000449','10105690'"
>
>
>Any ideas how I can pass a string with variable number of ids and run the select statement?
--sb--