Transpose problem...

Hi all,
I've got this problem. My original table is:

CODE | STOP_1 | STOP_2 | STOP_3
001  | ABC    | DEF    | GHI
002  | LMN    | OPQ    | RST

Where CODE is my primary key.
I'de like to get a view that gives the result in this form:

CODE | STOPS_LIST |
001  |  ABC       |
001  |  DEF       |
001  |  GHI       |
002  |  LMN       |
002  |  OPQ       |
002  |  RST       |

I've played around DECODE but seems to solve the reversed problem. Thanks in advance. Received on Tue Jul 23 2002 - 04:57:28 CDT