Replace a value in a comma separated string in SQL database

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"

Skills: .NET, Microsoft SQL Server, SQL

See more: sql function to split comma separated values, how to insert comma separated values in sql server, search comma separated values in sql server, how to get column values in comma separated sql server, how to split comma separated values into rows in sql server 2008, split comma separated values in sql server 2008, sql split comma delimited string into rows, sql split delimited string into columns, can replace missing sql database tables, array_unique convert array comma separated string php, add comma separated values sql server, convert comma separated value file outlook, cut replace table sql database, comma separated value url, read csv comma separated value asp net, comma separated file sql express, categories product comma separated sql, replace table sql database, asp connection string sql 2005 database, recieve sms text mesages sql database

About the Employer:
( 116 reviews ) Charleston, United States

Project ID: #15879728

Awarded to:


I am full stack developer. I possess strong knowledge on SQL, PL-SQL with MySQL, Oracle, MS SQL Server and DB2. I am sure I can do this in very short time and within limited budget. Trust me and I will not disappoint y More

$16 USD in 1 day
(1 Review)

15 freelancers are bidding on average $23 for this job


Hi there. I am .net and sql server expert. I am ready to help you now.

$50 USD in 1 day
(64 Reviews)
$29 USD in 1 day
(18 Reviews)

Hello, I'm interested to work on this. I have good experience in Sql Thanks, Sheik

$20 USD in 1 day
(22 Reviews)

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.

$25 USD in 0 days
(6 Reviews)

Hi, I'm .Net Developer. Contact me for Quality. Strong Skills:.Net,C#,MS SQ Waiting for your response. Thank you!

$30 USD in 1 day
(8 Reviews)

Greetings !! Myself Richa Miglani and I have more than 5+ year experience in Asp.Net. I read your job description and understand that you are looking good developer who has good experience in .Net Project I More

$20 USD in 1 day
(8 Reviews)

Dear! How are you? I have carefully read your project description and recognized that your project is very familiar with my skills. I am very interested in your project. I have gone through your REQUIREMENT.I can he More

$10 USD in 1 day
(2 Reviews)
$20 USD in 1 day
(3 Reviews)

Dear sir , i have experience in designing and development . please assign me the task Looking forwards , Regards

$15 USD in 1 day
(1 Review)

Dear reader, I have more than two years of professional experience in MSSQL development. I hope you will take my bid in consideration. Thank you.

$15 USD in 1 day
(1 Review)

Hello sir, - I have a good experience in .NET, Vb, C# - I worked as team player, remotely and in office. I know how to manage my time effectively. - I do not afraid overtimes and emergencies. During launching some More

$25 USD in 1 day
(1 Review)

hello, i have gone through your condition and need to ask some question kindly connect with us to have a little discussion about your task i have an experience in Software Development specializing in Asp.Net wi More

$25 USD in 1 day
(3 Reviews)
$18 USD in 1 day
(0 Reviews)

I am a experienced professional with experience close to 6years.

$26 USD in 1 day
(0 Reviews)