Re: Sql Code to Find Something

Rene Nyffenegger wrote:
> select email_addr from emx_table where instr(email_addr,'@') = 0;

good solution !
perhaps you could also exclude those adresses with more than one '@':

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

have fun
Hermann Received on Sat Mar 15 2003 - 11:09:39 CST