Simple way to do this without function

Create table #t(t varchar(10))

INSERT INTO #t VALUES ('1,2,3')

INSERT INTO #t VALUES ('3,4,5,11')

select * from #t

where t like '%1%' and t not like '%11%'