Re: Between function in Decode statement

I have a question that I couldn't get answered in any of the examples. Can I mix datatypes in a given CASE?

Foe example,
CASE WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 0 AND 30) THEN 'CURRENT'
            WHEN ((ROUND ( SYSDATE - REQUEST_LOG_DATE )) BETWEEN 31 AND 60) THEN 30
etc...

"DFN" <Iam_at_cyberspace.net> wrote in message news:btc4uj$520ri$1_at_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 - 11:32:48 CST