Decode doubt

Hi

Could anyone tell me whats is the equvilant of IIF in Oracle? Means:

I want to do this:

IIF (A > 0, 100) Our decode just compares with the ' = ' it doen't do the > or < operations. I could only write decode(a, 0, 100) I want to write decode(a, > 0, 100) or something like this

Can anybody give me a clue on this?

Thanks

V Prakash
venkatprakash_at_hotmail.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 17:33:37 CDT