Muthu Annamalai schrieb:

> Hi Luc:
>
> Look into the following Stored Procedure
>
> SELECT COALESCE(SUM(AMOUNT),0) FROM RECEIPT
> WHERE CAST(RECEIPTDATE AS DATE) = :SALESDAY AND
> PAYMENTID =7
> INTO :CHECKSALES;
>
> This is part of the same stored procedure, this is actually
> returning zero if there is no matching row in table. Here the table
> is different table, but for given salesday there is no record.

Yes, but you're using a SUM function here.

This is NOT the same as a plain select.
The result of SUM itself is initialized with NULL, so the coalesce
works. ;-)


Luc.