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]
--
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]
