try like this
declare @MyVar varchar(32)
set @MyVar = '1,5,7'

SELECT *
FROM mytable
WHERE '%,'+ @MyVar+',%' like '%,'+ convert(varchar(32),myid)+',%'