Re: Sql Code to Find Something

> Anyone if interested:
>
> How to extract those email address entries without @ sign?

select email_addr from emx_table where instr(email_addr,'@') = 0;

hth
Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html