Extracting data in a record from XML in SQL Server column

[aliciamagic]

I have a column with xml data type like this:\[code\]<Test ID="rs232lon"> <Param Name="corel" Value="http://stackoverflow.com/questions/14418256/0.00000" /> <Param Name="co2rel" Value="http://stackoverflow.com/questions/14418256/10.8000" /> <Param Name="hcrel" Value="http://stackoverflow.com/questions/14418256/111.000" /> <Param Name="o2rel" Value="http://stackoverflow.com/questions/14418256/0.95000" /> </Test>\[/code\]How could I get a result with TSQL like this :\[code\]corel co2rel hcrel o2rel------------------------------------------ 0.00000 10.8000 111.000 0.95000\[/code\]