I have a field in a MS SQL 2014 DB that stores comma separated values. What I need to do is to replace one value with another. so if I need to replace all 2's with a 3 then every 2 will be replaced except it will be removed if there is already a 3 there. So 1,2 will become 1,3 and 1,2,3 will become 1,2 and 4,5 will stay the same 4,5 and 2 will become 3. I need a function that I can pass the values and the replacement value. fn_change("1,2,3", "3") and get returned "1,3"
15 freelancers are bidding on average $23 for this job
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I can help you with you request right now, and have this done in less than two hours.