Hi all brainiacs
Please help.

I got a need to write a query as follows.

Table:
ID , Col_1, Col_2, Col_3, Col_4, Col_5, Col_6

query should return.
ID Col
== =====
ID Col_1
ID Col_2
...
ID Col_6

any solution other than Union?
Also should satisfy SQL Svr 2K

Cheers