At 01:17 PM 09-11-00 +0000, you wrote:

>I went a function like NVL(arg1,arg2) for Interbase
>
>if arg1 is null
> result= arg2
>else
> result= arg1
>end if;
>
>for any kind of datatype in arg1 and arg2
>
>if you know Oracle, you know this function.
>
>Anybody know a function like this function.

NULLIF(), right? Not currently supported, but on the Agenda for Firebird 1.

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________