SQL to convert 0 to NULL

[MSIsam]

I am new to ORACLE syntax and need the SQL code to convert zero to NULL. I am used to Teradata that has a NULLIFZERO function.

Any help would be much appreciated,
Sam

 

[johnherman]

Here's an example which may help

SELECT Keyfield,
CASE numberfield
WHEN 0 THEN NULL
ELSE numberfield
END
FROM tablename

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[SantaMufasa]

Sam,

Here is a tighter code alternative to John's fine suggestion:

SELECT KeyField, decode(numberfield,0,null,numberfield)
FROM tablename;

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:37 (03Sep04) UTC (aka "GMT" and "Zulu"), 09:37 (03Sep04) Mountain Time)