Update Query for string replace in sql server

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 Jan 09 '15 at 11:37 — slavoo, Jan 09 '15 at 11:37

score 2 · Accepted Answer · answered Jan 09 '15 at 11:37

2

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

answered Jan 09 '15 at 11:37

davek

Thanks...but this will update all 'a' with 'B'..i want Only AA with BB – pradeep Gavhane Jan 09 '15 at 11:43
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). – davek Jan 09 '15 at 11:47

score 0 · Answer 2 · answered Jan 09 '15 at 11:40

0

You can use

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

and update you column.

answered Jan 09 '15 at 11:40

Kishore Kumar

2 Answers2