Re: Between function in Decode statement

From: DFN <Iam_at_cyberspace.net>
Date: Mon, 5 Jan 2004 11:55:26 -0500
Message-ID: <btc4uj$520ri$1@ID-157477.news.uni-berlin.de>

I stand corrected Mr. Morgan. Two of us from my team were trying unsuccessfully but our syntax was erroneous. Thank you for the clarification.
JD

SELECT "REQUEST_NO","REQUEST_LOG_DATE", round (sysdate - REQUEST_LOG_DATE) aging,

CASE WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 0 AND 30) THEN NULL WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 31 AND 60) THEN 30 WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 61 AND 90) THEN 60 WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 91 AND 120) THEN 90 ELSE 120 END AGING_DECODED from ART_REQUEST A

where A.REQUEST_STATUS = 'H' OR A.REQUEST_STATUS = 'P'

And A.REQUEST_NO NOT IN (SELECT B.REQUEST_NO FROM ART_REQUEST_LETTER B) Received on Mon Jan 05 2004 - 10:55:26 CST