Suoritettu

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"

Taidot: .NET, Microsoft SQL Server, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 116 arvostelua ) Charleston, United States

Projektin tunnus: #15879728

Myönnetty käyttäjälle:

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 Lisää

$16 USD 1 päivässä
(1 arvostelu)
1.9

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

manhpham

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

$50 USD 1 päivässä
(64 arvostelua)
5.7
$29 USD 1 päivässä
(18 arvostelua)
5.2
sheikDev

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

$20 USD 1 päivässä
(22 arvostelua)
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 päivässä
(6 arvostelua)
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 päivässä
(8 arvostelua)
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 Lisää

$20 USD 1 päivässä
(8 arvostelua)
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 Lisää

$10 USD 1 päivässä
(2 arvostelua)
2.9
$20 USD 1 päivässä
(3 arvostelua)
2.2
IOTAONAIR

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

$15 USD 1 päivässä
(1 arvostelu)
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 päivässä
(1 arvostelu)
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 Lisää

$25 USD 1 päivässä
(1 arvostelu)
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 Lisää

$25 USD 1 päivässä
(3 arvostelua)
0.1
$18 USD 1 päivässä
(0 arvostelua)
0.0
Prajyotm90

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

$26 USD 1 päivässä
(0 arvostelua)
0.0