Help me out on tricky SQL!

Hi, there?

Could you help me out to solve a tricky SQL?

Create table Table1 ( A char(1), B int)

insert into Table1 ( 'a', 1)
insert into Table1 ( 'b', 2)
insert into Table1 ( 'c', 3)
insert into Table1 ( 'd', 4)

Table1
A      B
--- ---
a      1
b      2
c      3
d      4

Based on the above data, how can I display like below...

Desired output

col1 col2 col3 col4

   a        b       c       d
   1        2        3       4

Thanks in advance... Received on Tue Sep 11 2001 - 00:59:49 CDT