Table conversion ??

[Jinsoo Hwang]

Hi,

I have a following table.

 create table d_quotes (
   com_code  char(12),
   q_day         date,
   c_price       int
   )

There are around 1500 distinct com_code(company code) and
daily closing price(c_price) of their stocks are coded from
19830304-20000904(q_day).

What I am trying to do is to make a new table (day by com_code)
after 19970101.
Say,
--------------
                  code_1       code_2 .....   code_1500
19970104     c_price
19970105        ....
.....
---------------
Any help ?

Jinsoo Hwang