parse xml data

[Jacob438]

I have some data stored in a database column that looks like this in a long varchar field:

<xml><instanceID>49926</instanceID><name>Jay Bartels</name><address>555 Madison Avenue</address><phone>650 555 1212</phone><comments>Please only call in an emergency</comments></xml>

Is there a way i could easily get the data to look like this in a view:

col value
Name Jay Bartels
Address 555 Madison Avenue
Phone 650 555 1212
Comments Please only call in an emergency

So basically I'm asking if there is a way to retrieve the data from that one column, then create a view with the parsed data. Thanks,

Jacob438

 

[rac2]

Here is a place to start.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9oj8.asp