If the other suggestions don't work, try seeing what REQUEST.prefix is
turning into, you may be looking at the wrong table.
Ade
-----Original Message-----
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 17:59
To: CF-Talk
Subject: MS-SQL 2000 NULL Problem
How come a simple query like this still returns NULL for emails even though
my WHERE clause says to exclude them? What am I doing wrong? I've tried
both IS NOT NULL and <>.
SELECT L.email, L.firstname, L.lastname, L.directEmailTo
FROM #REQUEST.prefix#_Members_List L
WHERE L.email IS NOT NULL
ORDER BY L.email
Thanks, Mark
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- MS-SQL 2000 NULL Problem Mark Leder
- RE: MS-SQL 2000 NULL Problem Robertson-Ravo, Neil (RX)
- RE: MS-SQL 2000 NULL Problem Schuster, Steven
- RE: MS-SQL 2000 NULL Problem Mark Leder
- Re: MS-SQL 2000 NULL Problem Nick de Voil
- RE: MS-SQL 2000 NULL Problem Adrian Lynch
- RE: MS-SQL 2000 NULL Problem Tangorre, Michael
- RE: MS-SQL 2000 NULL Problem Schuster, Steven
- RE: MS-SQL 2000 NULL Problem Mark Leder
- Re: MS-SQL 2000 NULL Problem Nick de Voil
- CFTHROW in a CFC/Webservice Alexander Sherwood
- RE: MS-SQL 2000 NULL Problem Adrian Lynch
- RE: MS-SQL 2000 NULL Problem Casey C Cook