>>>>> "g" == grant <[EMAIL PROTECTED]> writes:
g> However, the last time i checked, NULL does not equal to 1, 2, 3,
g> or anything else besides NULL. Thats why I'm confused as to why
g> SELECT column FROM table WHERE column != 1 also excludes NULL,
g> because 1 does NOT have the same value as NULL.
Ok, NULL is not equal to 1, 2, 3, or anything else. It is also not
equal to itself, and it is not inequal to anything. NULL is special.
If you want to treat it the same as zero in your app, then you are
setting up your tables incorrectly. Make your column "NOT NULL
default 0".
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
