>I have a old appliaction to be update.The program who develop this system think that he need a table can be add more field later, so he create a table like this:

>ID n(10), fieldname c(50), fieldvalue c(50)

>If there are 2 field now, the table's content will like this:

ID fieldname fieldvalue
__________________________________
1 field1 value1 of 1
1 field2 value2 of 1
2 field1 value1 of 2
2 field2 value2 of 2
3 field1 value1 of 3
3 field2 value2 of 3
...

>My question is: How can i use a sql statement to transform this structure into a normal cursor ?

field1 field2
__________________________
value1 of 1 value2 of 1
value1 of 2 value2 of 2
value1 of 3 value2 of 3
.... 

Can you redifine your question with another meaningful sample?, I can understand what exactly want to do. It'll help with meaningful fieldname & values.