Replace string

I need to replace a string in multiple records ( '386-') with another ('701-386-') without affecting the rest of the record.Basically search and replace.
Can this be done with an SQL statement??

Thanks

so if i understand you well you have a table and in this table is field(field_1) whit holding char data "386-" and you need to replace it whit another char tada, but not affecting other table data.
So search and replace your tada:

UPDATE Table
SET field_1 = "701-386-";
where ID=0;

ID|field_1
- |----------|
0|386-

becomes:


ID|field_1
- |----------|
0|701-386-


i hope it will help you.