You will be better generating an SQL script of all the stored procs
into one file.

open it up in textpad/notepad and do a find replace.

then run the script again.

Jay Freeman

we're updating currencies used in a database, so things like "US" become
"USD". it's simple enought to run a few update statements on the tables
where currencies are used to consolidate the old definitions to the new, but
what about updating all the stored procs that still want to find currencies
called "US"? is there a simple way to do a find/replace with stored procs?

tks