Hello all.
Ive got a table with a field that is varchar(80). This field has a URL
in it. Unfortunately when the data was entered some of the URL's are
hardcoded with the IP number. For example:
http://207.200.200.2/yada/yada.ra
I need to replace the 207.200.200.2 with the domain name. Ive been
searching and reading for the last day or so, and cannot find an easy
way to do this without exporting it to an ascii file, then doing a find
and replace in there, and then re-importing it. Can anyone suggest some
way that I could modify it using sql? Thanks much,
Darren
