-----Original Message-----
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 1:32 PM
To: CF-Talk
Subject: RE: MS-SQL 2000 NULL Problem
Thanks for all your responses, unfortunately nothing has worked. I did
verify that it was selecting from the correct table.
All the empty fields in the email db contain <null>. Good suggestion to try
<> ''.
I'm going to do a look up on a different criteria.
Thanks, Mark
-----Original Message-----
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 1:09 PM
To: CF-Talk
Subject: RE: MS-SQL 2000 NULL Problem
Is the field storing NULL or blanks space, there is a difference.
Steve
-----Original Message-----
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 12:59 PM
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]
