Re: Sql Problem

From: Geoff Reader <grr_at_NOSPAM.bton.ac.uk>
Date: Fri, 31 Aug 2001 10:42:19 +0100
Message-ID: <3B8F5BFB.B4320F79@NOSPAM.bton.ac.uk>

Look at SUBSTR
and also INSTR

teh select statement will look unwieldy but it should work.

Good luck

Geoff
Geoff Reader
Analyst Programmer
University of Brighton

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
Received on Fri Aug 31 2001 - 04:42:19 CDT