Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vmon
Yak Posting Veteran
63 Posts |
 Posted - 2009-09-17 : 09:30:18
|
| I have a column that is defined as varchar, see below. The column actually contains xml. I would like to select the 3 colums from this string but have never worked with xml. How can I get the columns from this string?size<MED>placement<04>url<http://qa-media.custom.com/ugimages/076/401/500/tshirt.png>Thanksvmon |
|
|
asgast
Posting Yak Master
149 Posts |
Posted - 2009-09-18 : 03:37:00
|
| http://www.15seconds.com/Issue/050803.htmthis helped me a lot when i had to do select data from xml |
 |
|
|
|
|
|
How to get column from string of xml