Re: [ cf-dev ] cleaning email lists...

[Stephen Moretti]

SELECT ID FROM Email
WHERE Locate('@',email) = 0
Probably more efficient than NOT LIKE '[EMAIL PROTECTED]', but no idea if it'll work 
in access...  Definitely ok in mySQL.....

You can probably find an equivalent...

Ian Westbrook (FDM) wrote:
got a bit of a mental block this morning - can anyone throw me the code 
to select emails from a field where the email _doesn't_ contain an '@' 
<mailto:'@'> symbol?
 
something like
 
SELECT id FROM email
WHERE email does not contain '@' <mailto:'@'>
 
TIA
 
Ian W
 
 
--
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
     *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
          *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]