Ian, it better be true for all those implementations -- because this is what the ANSI/ISO standard is telling us to do ;-) please, invite me to teach my favorite one-day seminar on this topic ... Kind regards, Lex. ------------------------------- visit http://www.naturaljoin.nl ------------------------------- skype me <callto://lexdehaan> -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of MacGregor, Ian A. Sent: Thursday, September 02, 2004 19:43 To: oracle-l@xxxxxxxxxxxxx Subject: Consistent Null Handling One of the posts on "Cure for Madness" brought up consistent null = handling which Oracle does not do. For instance, "Select Column1 + Column2 from TableA;" returns null if either or both = columns are null. However "Select sum(Column1) from table A" will = return a value if there are non-null values in the column. Is this true = for all SQL versions? =20 Ian MacGregor Stanford Linear Accelerato Center ian@xxxxxxxxxxxxxxxxx --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004 -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004