converting NULL to Numeric 0

[shuklix]

Hi All,

I have a query of the type

select expr1 + expr2 from T

either of expr1 or expr2 may be null.

I get a NULL when one of them is NULL,

is there a way to change it to 0 ?

TIA,
Saurabh

 

[swampBoogie]

select coalesce(expr1,0) + coalesce(expr2,0) from t

 

[TootingBoy]

You could try using the IsNull() function.

E.g. Select IsNUll(expr1,0)+ IsNull(expr2,0)

If either expr1 or expr2 is null the function will return 0 (or any other value you want to use as the second parameter for the function).


The path to freedom is seldom trodden by the multitude.