Re: Setting Null values to Zero
From: Noshad Ahmed <noshad_at_blueyonder.co.uk>
Date: Sun, 7 Mar 2004 20:57:47 -0000
Message-ID: <7VL2c.7$CR5.0_at_news-binary.blueyonder.co.uk>
Date: Sun, 7 Mar 2004 20:57:47 -0000
Message-ID: <7VL2c.7$CR5.0_at_news-binary.blueyonder.co.uk>
try using NVL function...hence replace all null values with zeros and
perform a sort.
"C. Lo" <starshipdb_at_hotmail.com> wrote in message
news:713a6263.0403061026.3dfed2bb_at_posting.google.com...
> Hi
>
> I have a situtation where a query returns a table in which some of the
> values are null. When I sort the results, the null values are treated
> as greater than the other numerical results. Is it possible to set the
> database treat the null values as zero?
>
> Thanks
Received on Sun Mar 07 2004 - 21:57:47 CET