select from string field , separated SqlServer

select from string field , separated SqlServer

i have table1 that has field contains value separated with ','
name value
--------------------------
test 1,2
flower 3
car 4,2
dog 2
i want select command that find rows contains specific value in this column
string @value = 2
select * from table1 where ?
name value
--------------------------
test 1,2
car 4,2
dog 2