Hi,

try COALLESCE if using FB 1.5

e.g.

DISCOUNT = COALLESCE(DISCOUNT,0);


MA> I struggling with my SP to avoid returning null to client, but it
MA> doesn't work.I have given my SP here. I am trying to retrieve items
MA> that have discount, if no such item found then I want my SP to
MA> return zeros instead of nulls.

MA> Refer the SP Line "IF(:DISCOUNT IS NULL OR :SCHEME IS NULL)THEN"

MA> Any help appreciated

MA> Regards,

MA> Muthu Annamalai

<-- Snip -->


Björn

--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de