Re: IS (NULL = 1) equal to NOT(NULL = 1)?
From: Frank Bommarito <75662.112_at_CompuServe.COM>
Date: 1996/08/23
Message-ID: <4vk73a$47k$1_at_mhadg.production.compuserve.com>#1/1
Date: 1996/08/23
Message-ID: <4vk73a$47k$1_at_mhadg.production.compuserve.com>#1/1
A null -- (i.e. The absense of value) is not equal to anything.
So, it is not equal to 1 -- and - and is not -- not equal to 1.
Any direct comparison of a null - with IS NULL or will compare false.
NULL=NULL also compares false. If this compared true - then - NULL must have something (not absense of everything).
Hope this helps.
Frank
Received on Fri Aug 23 1996 - 00:00:00 CEST