Re: Replace part of a string using SQL

Thanks for your reply Rob
Its got to be because its Friday - or something.
As soon as I emailed my question - there it was
I'm such a doofus


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 06/26/2009 11:17:58 AM:

http://publib.boulder.ibm.
com/infocenter/iseries/v6r1m0/topic/db2/rbafzscareplace.htm

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
Alan Shore <AlanShore@xxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
06/26/2009 11:08 AM
Subject:
Replace part of a string using SQL
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



Morning everyone
we have just been informed that a particular domain name is being changed
to some other value
We therefore have to change all the applicable e-mails
Maybe my memory is playing tricks, but I seem to think that there is a
REPLACE function in SQL.
Problem is - I cannot find it.
Or is it a case of using substr with length etc?



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.