SELECT ID FROM Email WHERE Email NOT LIKE '[EMAIL PROTECTED]' ?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Ian Westbrook To: "CFUG List" <[EMAIL PROTECTED]> \(FDM\)" cc: <[EMAIL PROTECTED] Subject: [ cf-dev ] cleaning email lists... eam.net> 23/03/2004 11:13 Please respond to dev 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 '@' symbol? something like SELECT id FROM email WHERE email does not contain '@' 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]
