SELECT I64NVL(MYCOLUMN, 0) ...
SELECT I64NULLIF(MYCOLUMN, 0) ...

both results are wrong. The only result I need is 0 when MYCOLUMN is NULL,
otherwise the value of MYCOLUMN.

Ales

> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: Friday, July 26, 2002 8:07 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] ISNULL
>
>
> Hi,
>
> my first guess would be to use I64NVL or I64NULLIF.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
> > Hi All,
> > can you help me with the 'ISNULL' problem?
> > I have tried the tbudf.dll where some NULL functions are in
> this dll.
> > Suppose you have table
> >
> > CREATE TABLE MYTABLE (
> > ...
> > MYCOLUMN NUMERIC(15,2);
> > ...
> > )
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/NsdPZD/PfREAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/