MS-SQL 2000 NULL Problem

[Mark Leder]

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]

---