Here is a quicky to replace a string inside a column:

update yourTable set theColumn = replace(theColumn,'oldString','newString')