Re: Sql Problem

From: news.aon.at <s.katschthaler_at_tirol.gv.at>
Date: Thu, 6 Sep 2001 10:07:34 +0200
Message-ID: <3b972ec7$0$27372$6e365a64@newsreader02.highway.telekom.at>

UPDATE table
SET email = replace(email,'firma-bla.de','firma.de');

should update all records

"Thomas Gorn" <thomas_betsabe_at_t-online.de> schrieb im Newsbeitrag news:3b8d5647$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
>
>
Received on Thu Sep 06 2001 - 03:07:34 CDT