Re: Update Problem

Thank you,
it works.

Tom

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:toqt2n13rpnc51_at_news.demon.nl...
>
> "Thomas Gorn" <thomas_betsabe_at_t-online.de> wrote in message
> news:3b8d562e$1_at_news.piro.net...
> > Hello,
> >
> > I have a table with userdata on Oracle DB.
> > In one field I store the email. Now the mail adress
> > firstname.surname_at_firma-bla.de have changed to
firstname.surname_at_firma.de
> .
> > Can I realized this with a sql statement?
> >
> > Thanks
> >
> > Tom
> >
> >
>
> Yes
> You need to use the replace function.
> Please look it up in your sql reference manual.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Thu Aug 30 2001 - 22:57:12 CEST