On Mon, Dec 9, 2013 at 2:42 PM, Javier Valencia < [email protected]> wrote:
> Karen, > > > > Is there a reason why SET EQNULL should not be left as ON by default? Why > would you set it to OFF as default > > > > Javier, > > Javier, At the risk of starting another discussion of "three-value logic", let me just say that by definition in the ANSI SQL Standards, going back to the 1980s, a null value cannot ever be equal to any value, not even another null, because it represents an "unknown" value. Bill
