Another approach is to convert the list into a table and then run your query against the table. Here's an example using @strParams as your passed parameter string.

declare @strParams varchar(100) = '1,14,65,234,16443,145,1669,2';

select column_list

from table_name

where exists (select 1

from DelimitedSplit8K(@strParams, ',') s

where s.Item = table_name.some_id_field);

If you haven't used Jeff Moden's string splitter, I highly recommend it. It'll change the way you look at strings and your expectation of performance. It is at http://www.sqlservercentral.com/articles/Tally+Table/72993/.