update [table_name] set [field_name] = replace([field_name], ‘[string_to_find]’, ‘[string_to_replace]’);
Replace within a field
update [table_name] set [field_name] = replace([field_name], ‘[string_to_find]’, ‘[string_to_replace]’);
Replace within a field