'How to check comma separated value is already exists in SQL column?

I have column in table as Deleted_Questions and its values are like e.g. - 1,2,4,7,10

While inserting a new value in this column how we can check string is already exists , In my case I am going to insert string value like '4,' which is already exists in column.

sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source