I have table named priacc with 100 columns.
Column names are a001,a002,a003...a100.
How to create view so that this row become column named "desc". Result shoud be:


desc
-------------------
value from a001
value from a002
value from a003
value from a004
.
.
.
value from a100

Table is always filtered by id which is in a100 column so I always have only one row as result.

Edited by - Pere on 14 Dec 2003 11:37:20