Matrix select with SQL: is it possible?

I have a table with 3 fields:

column:   Object            axes                value

Datas:       Oi                   Xi/Yi                Vi

the field axes is always with the same separator (/)

i 'd like to obtain a matrix result with sql:

                       Yi
Oi        Xi        Vi

example of table

Object        axes         value
O1             A1/B1      V1
O1             A2/B1      V2
O1             A1/B2      V3
O1             A2/B2      V4

result wanted:

            B1 B2
O1 A1 V1 V3
O1 A2 V2 V4

Is it possible and how can i do?

thanks Received on Thu Oct 25 2001 - 04:03:48 CDT