| Subject | Re: [firebird-support] coerce null to 0 |
|---|---|
| Author | Jason Dodson |
| Post date | 2006-06-26T14:46:36Z |
You have it backwards:
select sum(coalesce(amt,0))...
amt being the field to evaluate
0 being the value to replace null with
Nick wrote:
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
select sum(coalesce(amt,0))...
amt being the field to evaluate
0 being the value to replace null with
Nick wrote:
> select sum(coalesce(0,amt)) ...--
>
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.