sql 2005 xml searching

[nick chan]

hi i have a table with an XML column

this XML data looks like this

<attribute id="3" value="z"/></details>

could anyone help guide me on how to search something like this?

 

[rote]

nick post it to the xml newsgroup and u will get a prompt reply

 

[nick chan]

thanks a lot !!

nick post it to the xml newsgroup and u will get a prompt reply

hi i have a table with an XML column

this XML data looks like this

could anyone help guide me on how to search something like this?