4 Sep
2001
4 Sep
'01
3:47 p.m.
"J. Cone" wrote:
I don't know about other databases, but you can get the result you want in Oracle with the nvl function, by selecting
nvl(optional_number, 0)
from the database. If you couldn't control the replacement value and 0 had an exisiting meaning, I would think that disastrous.
I know the NVL trick, it works. Almost. It yields 0.0 for an integer, I want it to be 0. I tried Round(nvl(optional_number, 0), 0) got me 0.0 for null -- Stig-Arne Nordin | Projektledare Fysik och teknisk fysik CHALMERS | Göteborgs Universitet tel 031 772 32 07 | fax 772 3202 http://www.fysiksidan.nu