replace sub string in SQL Server

Question

I have a column in my table called "service". This has value like below.

0.0.0.1 /service/telco/fixedline/**intnet** 274511977 0

I need to replace this as below

0.0.0.1 /service/telco/fixedline/**_intnet** 274511977 0

If you notice this you could see that wherever the substring "intnet" is coming , all the occurances of it should be replaced with "_intnet".

What have you tried? Have you searched for "replace string SQL Server", or similar, on your preferred search engine? (hint: REPLACE (Transact-SQL)) — Thom A
– Thom A ♦, Commented Oct 24, 2018 at 10:24

Yogesh Sharma · Accepted Answer · 2018-10-24 10:25:15Z

2

I would do :

select stuff(col, charindex('intnet', col), 0, '_')

You can also use replace() :

select replace(col, 'intnet', '_intnet')

answered Oct 24, 2018 at 10:25

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Barry Piccinni Over a year ago

Prefer this answer as it uses the column name rather than the literal string. I think it's safe to assume the value of each row will be different, rather than the exact same string over and over.

Katusic · Accepted Answer · 2018-10-24 10:25:26Z

2

select replace ('0.0.0.1 /service/telco/fixedline/intnet 274511977 0','intnet','_intnet')

answered Oct 24, 2018 at 10:25

Katusic

845 bronze badges

Collectives™ on Stack Overflow

replace sub string in SQL Server

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related