Dear All,

Is there any isnull function on IB, like SQL SERVER :
example :
select isnull(value_nr,0) from tablename;
so when the data is null, it's show 0 not <NULL>

Regards,

Hellen Huang