DECODE with a range values
From: Hagai Katz <katzh_at_bgumail.bgu.ac.il>
Date: Mon, 16 Jul 2001 16:29:40 +0300
Message-ID: <9iuq84$i0f$1_at_news.huji.ac.il>
Date: Mon, 16 Jul 2001 16:29:40 +0300
Message-ID: <9iuq84$i0f$1_at_news.huji.ac.il>
Hi all.
I wondered if anyone could explain and give an example how to a DECODE with
a range of values and with multiple values, for example if I want to
translate the following:
0=A
1,2=B
3-5=C
6-10=D
11-50=E
51- ... =F
Thanks,
Hagai.
Received on Mon Jul 16 2001 - 15:29:40 CEST