Update Query for string replace in sql server [duplicate]

Question

i have table,

   id        Name   

   1      aaaaAAbbbb 
   2      bbbbAAaaaa 
   3      aabbAAbbaa

This is my table,i want to update 'AA' with 'BB' using sql server 2008

Did you try something ? What is problem ?

slavoo
– slavoo

2015-01-09 11:37:58 +00:00
Commented Jan 9, 2015 at 11:37 — slavoo
– slavoo, Commented Jan 9, 2015 at 11:37

davek · Accepted Answer · 2015-01-09 11:37:51Z

2

update myTable set [Name] = REPLACE([Name], 'AA', 'BB')

REPLACE applies to SQL Server 2008 upwards.

answered Jan 9, 2015 at 11:37

davek

23k11 gold badges80 silver badges97 bronze badges

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

2 Comments

pradeep Gavhane Over a year ago

Thanks...but this will update all 'a' with 'B'..i want Only AA with BB

davek Over a year ago

This probably means that your collation is set to case-insensitive. You can get around this by specifiying the collation that REPLACE should apply (see the link I referenced).

Kishore Kumar · Accepted Answer · 2015-01-09 11:40:40Z

0

You can use

 REPLACE(Name,'AA','BB');

and update you column.

answered Jan 9, 2015 at 11:40

Kishore Kumar

786 bronze badges

Collectives™ on Stack Overflow

Update Query for string replace in sql server [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related