that it is checked. Then the default will be NULL and not " " or something
else. Then as inserts occur you can be assured that NULL fields are actually
NULL and not equivelant nulls like " " or Null typed into a varchar field.
I know it sounds odd, and it is, but that's the way NULLS are...
-----Original Message-----
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 1:39 PM
To: CF-Talk
Subject: Re: MS-SQL 2000 NULL Problem
Mark
> All the empty fields in the email db contain <null>
How exactly do you know the email field is null? It seems to me that if
"WHERE L.email IS NOT NULL" returns the rows, then that's the surest proof
that the field is not null.
Nick
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
