Re: Between function in Decode statement

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 31 Dec 2003 16:13:24 +0100
Message-ID: <3ff2e738$0$28697$626a54ce@news.free.fr>

"DFN" <Iam_at_cyberspace.net> a écrit dans le message de news:bsuo2i$1jghm$1_at_ID-157477.news.uni-berlin.de...
> My apologies if this is not the right group for this question.
>
> I am trying to use a BETWEEN function in a DECODE statement and I am having
> a hard time.
> Does anyone know if it is not allowed?
> I have successfully used some of the other equality tests such as greater
> than, less than and equal to.
>
>

If you have a 9i version, use CASE instead of DECODE. If you have a pre-9i version and want to use between with numbers, have a look at SIGN.

Post your version and your entire issue and we can help you.

Regards
Michel Cadot Received on Wed Dec 31 2003 - 09:13:24 CST