Re: Sql Problem

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 31 Aug 2001 11:52:38 -0700
Message-ID: <3B8FDCF6.1F08B76F@attws.com>

Thomas Gorn wrote:

> 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

You should be able to do this with an update such as:

UPDATE userdata
SET your_field_name = 'firstname.surname_at_firma.de' WHERE your_field_name = 'firstname.surname_at_firma-bla.de';

Daniel A. Morgan Received on Fri Aug 31 2001 - 13:52:38 CDT