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 - 14:57:47 CST
