Much better than LIKE. n1 - Peter
-----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:35 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] cleaning email lists... 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] -- 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]
