SELECT id FROM email
WHERE charindex('@', email) = 0
> -----Original Message-----
> From: Stephen Moretti [mailto:[EMAIL PROTECTED]
> Sent: 23 March 2004 11:23
> To: [EMAIL PROTECTED]
> Subject: Re: [ cf-dev ] cleaning email lists...
>
>
> Heh heh, well at least one person had to come up with something that
> wasn't "NOT LIKE"... ;)
>
> > 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]
