Subject RE: [firebird-support] Problemas with SUM()
Author Wilson, Fred
It's working as it should..
What do you think it should return when you pass it a value of 10, and a
state of "unknown"..

NULL is a state (a state of unknown), NOT a value.. Any math done with a
NULL *must* return a null !!

For instance, what should 10 + "an unknown value" be equal to ?? It can
only be equal unknown.

Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>

-----Original Message-----
From: João Nelson [mailto:joaonelson@...]
Sent: Friday, June 27, 2003 12:37 PM
Subject: [firebird-support] Problemas with SUM()

Hello, =)
I am with problems SUM (). My Query returned NULL but my values is 10 and
NULL. Why?

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/6/2003

Yahoo! Groups Sponsor


o?YH=3313099&yhad=1595053> Click Here!


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<> .

[Non-text portions of this message have been removed]