RE: [ cf-dev ] cleaning email lists...

[Peter Harrison]

... WHERE email NOT LIKE '[EMAIL PROTECTED]'   - Peter -----Original Message----- From: Ian Westbrook (FDM) [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:14 To: CFUG List Subject: [ cf-dev ] cleaning email lists... 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