update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); Make sure and remove the [] tab when entering the variable. If you know how to do this database wide without needing the table listed please post in the comments.