gstackoverflow gstackoverflow - 4 months ago 18
SQL Question

replace all rows by rule

I have the table with varchar.
it contains values

a111
a112
a113
...


I want to repplce it like

b111
b112
b113
...


please help with update query

Answer
UPDATE dbo.xxx SET Value = REPLACE(Value, 'a', 'b') 

Hope this will help.