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?