hi i have a table with an XML column

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%")

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

"nick chan" <zzzxtreme [at] gmail.com> wrote in message
news:ca4e2830-ae06-4b9c-8dfc-9592634e4e97 [at] s13g2000prd.google groups.com...
> hi i have a table with an XML column
>
> 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%")

thanks a lot !!
On Apr 16, 4:57=A0pm, "rote" <naijaco... [at] hotmail.com> wrote:
> nick post it to the xml newsgroup and u will get a prompt reply
>
> "nick chan" <zzzxtr... [at] gmail.com> wrote in message
>
> news:ca4e2830-ae06-4b9c-8dfc-9592634e4e97 [at] s13g2000prd.google groups.com...
>
> > hi i have a table with an XML column
>
> > this XML data looks like this
>
> > <details><attribute id=3D"1" value=3D"x"/><attribute id=3D"2" value=3D"y=
"/
> >><attribute id=3D"3" value=3D"z"/></details>
>
> > could anyone help guide me on how to search something like this?
>
> > -------
> > Select * from Table Where (XMLColumn contains attribute of id=3D"2" and
> > value like "y%")