""Hellen Huang"" <hellen@...> wrote in message
news:001101c1aa27$11dc9600$3350a8c0@......

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

No built-in function. You can use

select 1 from tablename
where value_nr is null
UNION ALL
select 0 from tablename
where value_nr is not null

What's better is to know what are you really trying to do. Returning a
column with ones and zeroes or boolean values doesn't seem very important,
unless it's part of a more complex statement.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing