"Ryan" <ryanofford@hotmail.com> wrote in message
news:1105541454.722991.164290@f14g2000cwb.googlegr oups.com...
> I'm looking for a stored procedure (or query) to search an entire
> database for a specific string value and replace it with another. I'm
> sure I saw an SP for this a while back by someone, but cannot find it
> again. The SP took the search string and replace string as parameters
> and did the rest. Any ideas where I can find this ?
>
> Bear in mind, the idea is that this can be re-used and run on any
> database, so it would have to find all tables and search through those.
> Ta
>
> Ryan
>

Google found this:

http://groups.google.ch/groups?hl=en...jomn%404ax.com

You should probably read the whole thread - there are some comments and
corrections to the original code in later posts.

Simon