On 9/30/2015 10:31 AM, Ted Roche wrote:
Sum of NULLs and non-NULLs? The sum of all the non-null values
Wait, am I misunderstanding you? That sounds like your saying .null. + something = something.
One of the biggest bite-my-butts I constantly deal with is coming up with a null value instead of a number, because somewhere in one of the records I'm adding, there is a null and I forgot to NVL() it.
I just did this: MS SQL Query: print null + 5 -> (no output) VFP: ? .NULL. + 5 -> .NULL. What am I misunderstanding? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
