Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Code to Find Something
if you are looking for all rows where '@' is not present in a field try
where field not like '%@%'
"Steve" <schen_at_prodigy.net> wrote in message
news:b166c214.0303141415.2c7a0b2d_at_posting.google.com...
> Anyone if interested:
>
> How to extract those email address entries without @ sign?
>
> Example:
>
> table name: emx_table
> column_name: email_addr
>
> records like: xxx_at_abc.com
> xxxabc.com
>
> While email addresses have no pattern and record counts are thousands,
> so you cannot specify the xxxabc.com, etc..
>
> Appreciated.
>
> Steve
Received on Fri Mar 14 2003 - 18:12:45 CST