extracting data from xml data type field

[pijin10]

i have a field that data is stored in it with xml data type value :\[code\]<Inning xmlns="" ID="2866433" Company="Hamfekran"> <Test ID="rs232lon"> <Param Name="corel" Value="http://stackoverflow.com/questions/14437732/0.00000" /> <Param Name="co2rel" Value="http://stackoverflow.com/questions/14437732/10.8000" /> <Param Name="hcrel" Value="http://stackoverflow.com/questions/14437732/111.000" /> <Param Name="o2rel" Value="http://stackoverflow.com/questions/14437732/0.95000" /> </Test> <Test ID="9" Name="CustomData"> <param Name="TireFront" Value="http://stackoverflow.com/questions/14437732/3.00" /> <param Name="TireBack" Value="http://stackoverflow.com/questions/14437732/2.00" /> </Test></Inning>\[/code\]How could I get a result with TSQL like this :\[code\]corel co2rel hcrel o2rel TireFront TireBack----------------------------------------------------------------------------- 0.00000 10.8000 111.000 0.95000 3.00 2.00\[/code\]