decode function

Quote:

---

Originally posted by jmodic

Code:

---

DECODE(1, SIGN( SIGN(A-B) + SIGN(C-A)), 1, 0)

---

---

This stuff looks a whole lot like the greek in Joe Celko's Advance SQL book. I'll say now what I said then... Thank God for the CASE statement!!! ;)

- Chris

Quote:

---

Originally posted by chrisrlong

Quote:

---

Originally posted by jmodic

Code:

---

DECODE(1, SIGN( SIGN(A-B) + SIGN(C-A)), 1, 0)

---

---

This stuff looks a whole lot like the greek in Joe Celko's Advance SQL book. I'll say now what I said then... Thank God for the CASE statement!!! ;)

- Chris

---

Amen! ;)