How to change words in tables

I want to change all occurences of the word "fred" to "jim" in a number
(possibly all) of tables in the same database but cant seem to work out
how

can anyone help please

cheers

Col.