Re: AW: [HACKERS] isnull() or is it?t

Zeugswetter Andreas IZ5 wrote:
>
> > isnull() is on our TODO list.
>
> It should be called NVL() from "Null VaLue" like in Oracle and
> Informix.
> isnull() would suggest a boolean return value to me.
>

With SyBase, IsNull(X,Y) returns X if X is not null, and Y
if X is null.

Example:

SELECT reference, name, IsNull(price, 0.00)
FROM t_items

reference name price
------------ --------------- -------
W95 Windows95 190.00
WNT400 Windows NT 4.0 490.00
LX Linux 0.00

rather than:

SELECT reference, name, price,
FROM t_items

reference name price
------------ --------------- -------
W95 Windows95 190.00
WNT400 Windows NT 4.0 490.00
LX Linux NULL

--
H.Lefebvre