Re: ISNULL function

[Joe Aponte]

Hi friend, i had tested ifnull function with a tipycal example and all right, but i have a problem when the function is evaluating a value returned from a table.
Let me explain that.
My table have two fields:

roos_chamber (depth_cm decimal(4,2),
densidad_r50 decimal (10,3))
example:
--------------------------
dept_cm | densidad_r50 |
1.0 | 1.345 |
2.0 | 1.567 |
2.5 | 1.871 |
--------------------------

and the instruction is:
a) select ifnull(densidad_r50,0) as valor from roos_chamber where depth_cm = 2.5;
b) select ifnull(densidad_r50,0) as valor from roos_chamber where depth_cm = 2.1;

When the value is found (case (a), return the correct value; in otherwise (case (b), is returning null, and i am expecting zero (0).

Do you have any idea?, can you help me?
thanks before hand

Joe
(Web-Bond)