I need a sql server 2014 query for delimited lists

I am working with a delimited list in a table in database. My end goal here is to remap these categories, and I will be able to accomplish that by replacing some of these numbers in the delimited list. For example: number “429” anywhere in the delimited list needs to be replaced to the number “506”, and so on. I want to be able to query it in a way so that if “506” already exists in the delimited list, it shouldn’t duplicate it because then we will have it twice. I have a sample query ready for you to look at along with few examples so it really should be easy for you if you know sql server 2014.