Lets say I have a table with 2 columns, one of which is xml.
bob <root><Column name="haircolor">blue</Column></root>
jane <root><Column name="haircolor">green</Column><Column name="age">16</Column></root>
Is there a way to return the "haircolor" for a particular person? More generally, how can I get the value of element Column where name attribute is a particular value? is there a Select statement for this? I'm using Sql Server 2005