Re: how to find a string in a column?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 13 Jan 2002 22:09:04 +0100
Message-ID: <mpt34u4pm40aol8pafo746uu31h15rp3tc@4ax.com>

On Sun, 13 Jan 2002 21:54:47 +0100, "Karine Curfs" <karine.curfs_at_freesbee.fr> wrote:

>Hello
>I m searching for a string in a column. This string is like an e-mail :
>'karine.curfs_at_orange.fr' , for example. There can be caracters before the
>email or after the email.
>How can i find this?
>Thanks.
>Can u answer me to : karine.curfs_at_orange.fr, please?
>

Oracle invented the instr function for that purpose. Please refer to the sql reference manual for the exact syntax.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Jan 13 2002 - 15:09:04 CST