SQL query

From: <tmurrayiii_at_my-deja.com>
Date: Fri, 03 Nov 2000 21:38:24 GMT
Message-ID: <8tvb8g$1ln$1@nnrp1.deja.com>

Hi,

I am query this table:

SQL> desc order;

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 ORDER_ID                                  NOT NULL NUMBER(38)
 CUSTOMER_ID                               NOT NULL NUMBER(38)
 SERVICE                                   NOT NULL VARCHAR2(5)
 ORDER_NUMBER                              NOT NULL VARCHAR2(15)
 VOLUME                                    NOT NULL NUMBER(38)
 CHANNEL                                   NOT NULL VARCHAR2(10)
 ORDER_DATE                                NOT NULL DATE

The "VOLUME" field returns a 1 - 5 value. Is it possible to translate the returned value 1 to "low", 2 to "medium", 3 to "high" etc. in an sql query?

Thanks

Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 03 2000 - 15:38:24 CST