Re: Adding null values

[Ramalingam Chelliah]

Hi,

I think IFNULL() Function will help you do that...

In SELECT Statement where you need the sum of a and b

use this expression ...
IFNULL(a+b,IFNULL(a,b))

If you need 0 for the case where a and b are both null
IFNULL(a+b,IFNULL(a,IFNULL(b,0)))

Refer:
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html

Hope this helps you....

Regards,
Ram.


We Learn the Most When we have to Invent