Setting Null values to Zero

[C. Lo]

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

[Noshad Ahmed]

Re: Setting Null values to Zero

try using NVL function...henc e replace all null values with zeros and
perform a sort.
"C. Lo" <starshipdb@hot mail.comwrote in message
news:713a6263.0 403061026.3dfed 2bb@posting.goo gle.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