by stephen coe on Feb 12, 2012
update {table} set {field} = replace({field},'{string to find}','{replace with}');