Re: Between function in Decode statement

DFN wrote:

> It was frustrating because I had tried CASE as some folks had suggested but
> it has the same limitations that decode has with relational operators.

No it doesn't. You just did it incorrectly. Post your attempt at a solution using CASE.

But before you do visit: http://www.psoug.org/reference/decode_case.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)