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

[Peter Harrison]

lol, guess we got a question where we all know it.   ooh pick me, pick me, I know it! lol   - Peter -----Original Message----- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 23 March 2004 11:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] cleaning email lists... 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