calculated value in a DECODE statement

Hi all,

I'm a fairweather Oracle sql front ender and I need some help on a DECODE.

I have a numeric field that, if it is greater than 0, return the field, else return 0.

I've tried ;

 DECODE(numfield, > 0, numfield,0)
 DECODE(numfield, numfield > 0, numfield,0)
 DECODE(numfield, (numfield) > 0, numfield,0)

and several iterations and I now have no hair on my head.

Can anyone shed some light on this?

TIA,
Marc Miller
Commonwealth Telephone Company Received on Mon Mar 17 2003 - 15:26:13 CST