>Is there any isnull function on IB, like SQL SERVER :
>select isnull(value_nr) from tablename;

I don't know SQL Server, but I guess you're looking for something like

SELECT <whatever>
FROM tablename
WHERE value_nr IS NULL

HTH,
Set