เสร็จสมบูรณ์

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"

ทักษะ: .NET, Microsoft SQL Server, SQL

ดูเพิ่มเติม : 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

เกี่ยวกับนายจ้าง:
( 116 บทวิจารณ์ ) Charleston, United States

หมายเลขโปรเจค: #15879728

มอบให้กับ:

sarvya521

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 เพิ่มเติม

$16 USD ใน 1 วัน
(1 บทวิจารณ์)
1.9

freelancer 15 คน กำลังเสนอราคาเฉลี่ยที่ $23 สำหรับงานนี้

manhpham

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

$50 USD ใน 1 วัน
(64 บทวิจารณ์)
5.7
$29 USD ใน 1 วัน
(18 บทวิจารณ์)
5.2
sheikDev

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

$20 USD ใน 1 วัน
(22 บทวิจารณ์)
4.7
SergioAlfaroV

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 ใน 0 วัน
(6 บทวิจารณ์)
4.2
Zahidtanveer

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

$30 USD ใน 1 วัน
(8 บทวิจารณ์)
4.0
Brightinfotech3

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 เพิ่มเติม

$20 USD ใน 1 วัน
(8 บทวิจารณ์)
3.9
daisoftware123

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 เพิ่มเติม

$10 USD ใน 1 วัน
(2 บทวิจารณ์)
2.9
$20 USD ใน 1 วัน
(3 บทวิจารณ์)
2.2
IOTAONAIR

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

$15 USD ใน 1 วัน
(1 บทวิจารณ์)
1.1
fesej

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 ใน 1 วัน
(1 บทวิจารณ์)
1.1
nikunjv9

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 เพิ่มเติม

$25 USD ใน 1 วัน
(1 บทวิจารณ์)
0.3
vashist246

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 เพิ่มเติม

$25 USD ใน 1 วัน
(3 บทวิจารณ์)
0.1
$18 USD ใน 1 วัน
(0 บทวิจารณ์)
0.0
Prajyotm90

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

$26 USD ใน 1 วัน
(0 บทวิจารณ์)
0.0