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

[Damian Watson]

Could you use WHERE NOT LIKE ‘[EMAIL PROTECTED]’ ??   -----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