I've solved this by creating a function (named fnTabulate) that returns a table of the supplied integers.  I use it more than anticipated...

----------------------------------------------------------------------------

declare @StringIDs varchar(50)

set @stringIDs = '1,2,3,4,5,6,7,8,9'

select  t.ID

from   Table1 t,

  dbo.fnTabulate(@StringIDs)...