Validate Email Addresses

[aw23]

I have a query which returns all email addresses in the rs. Not all email addresses are valid. I'd like to validate them, where the rs only rturns those with "@" how can I add this to my where statment?

Thanks

 

[Golom]

WHERE Instr ( emailaddr, "@" ) > 0

 

[aw23]

Thanks! That worked. I'd give you a star but for some reason I can't. Everytime I try, my browser crashes.

 

[PHV]

Without any function call (ie pure SQL):
WHERE emailaddr Like '*@*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244