RE: Replace part of a string using SQL

[Alan Shore <AlanShore@xxxxxxxx>]

Thanks for the reply David
I feel such a fool. I just found it in the SQL reference manual
Why I didn't find it before?



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:14:41 AM:

> Here's an example I have used.
>
>
> UPDATE QCLSRC
> SET
> SRCDTA = REPLACE ( SRCDTA,
>                    'XXXXXX',
>                    '' *CAT &DISINO *CAT '')
> WHERE SRCDTA LIKE '%XXXXXX%'')
>
>
>
>
> > -----Message d'origine-----
> > De : midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Alan Shore
> > Envoyé : vendredi 26 juin 2009 17:00
> > À : Midrange Systems Technical Discussion
> > Objet : Replace part of a string using SQL
> >
> > 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.