this XML data looks like this
<details><attribute id="1" value="x"/><attribute id="2" value="y"/
><attribute id="3" value="z"/></details>
could anyone help guide me on how to search something like this?
-------
Select * from Table Where (XMLColumn contains attribute of id="2" and
value like "y%")