Clever clogs :-P
-----Original Message-----
From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:22
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] cleaning email lists...
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]
