Thanks Karen and Bill,
Now I remember. I will have to check my notes and see how it affects my applications. I know that I have several places in my code where I turn it ON and then OFF; I guess it was the easier way to deal with the issue at the time. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Monday, December 09, 2013 2:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DELETE DUPLICATES, Setting: SET EQNULL OFF 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
