How to select 0 as null

From: Kim Bundgaard <KIB_at_kmd.dk>
Date: 23 Jul 1999 14:33:53 GMT
Message-ID: <01bed518$8e162560$4c1414ac@h-11361.kmd.dk>

I'm not so familar with Oracle - so excuse for a potentially "not so intelligent" question.

How do I select a zero value as null, and all other values with is correct value. I want my resultset to have null instead of zero for the row where my column value is zero, and all other value should have their correct value (ie. 10, 125 and so on).

I can do it with som combination of union all and where clause, but that seems a little bit nasty.

Any suggestion would be appreciated.

/Kim Bundgaard Received on Fri Jul 23 1999 - 09:33:53 CDT