Works like a charm.
Thanx.
>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?
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.