(no subject)

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 19 Sep 2000 08:15:35 -0400
Message-Id: <10624.117332@fatcity.com>

How about using the REPLACE character function. ROR
>>> christine.turner_at_ips-sendero.com 09/18/00 05:46PM >>>
Hello All.........

I have an interesting request from a co-worker of mine. Listed below is = a=20
sub-set of data from a table in one of our databases. The request was = a=20
basic search and replace. Find all columns with the string "E:\Jun30=20 backup\" in them and replace it with "\\ServerName\backup\".

PATH_NAME

------------------------------------------------------------------------ =

=20

---

E:\April30 backup\daily_gl_baleom.prn
E:\May30 backup\dailyglbal.prn
E:\Jun30 backup\BORROWALS30.LST
E:\Jun30 backup\dda30.LST
E:\Jun30 backup\loans30.LST

Anyone have ANY ideas???? I'm a little stumped so any help is appreciated.=

Thanks!!!
Christine Turner
DBA
IPS Sendero
Scottsdale, Arizona

--=20
Author: Christine Turner
  INET: christine.turner_at_ips-sendero.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 19 2000 - 07:15:35 CDT