Find&Replace on a database table

Have you ever imagined how nice would be if you were able to run a find and replace on a database table?

It's possible!

You just need to run this query:

update [tablename] set [fieldname] = replace([fieldname],'[stringtofind]','[stringto_replace]');