SELECT L.email, L.firstname, L.lastname, L.directEmailTo
FROM #REQUEST.prefix#_Members_List L
WHERE L.email IS NOT NULL
AND L.email <> ''
ORDER BY L.email
_____
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]