Try this

Declare @Repids varchar(50)

Set @Repids = '2,8,9,12'

Set @Repids = ',' + @Repids + ','

Select *

From sales

join salesreps

on sales.repid = salesreps.repid

where CharIndex( ',' + cast( salesrep.repid as varchar(10))...