Re: IF-like function in Oracle?

Here is the trick ,

IF X > Y
THEN return value A as the column's value  ELSE return value B as the column's value

decode(sign(X-Y),1,A,-1,B,0,B)

Good Luck

---
Mani Maran                                       EDS Consultant
Voice: 214-828-.7572... Fax: 841-6886                999 Haskel
Commercial Services Division, Southland Account  Dallas, Texas 75... USA
"Opinions expressed herein are not necessarily supported by my employer."