sql 2005 xml searching

am 16.04.2008 07:14:08 von Nick Chan

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?

-------
Select * from Table Where (XMLColumn contains attribute of id="2" and
value like "y%")

Re: sql 2005 xml searching

am 16.04.2008 10:57:43 von naijacoder

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

"nick chan" wrote in message
news:ca4e2830-ae06-4b9c-8dfc-9592634e4e97@s13g2000prd.google groups.com...
> 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?
>
> -------
> Select * from Table Where (XMLColumn contains attribute of id="2" and
> value like "y%")

Re: sql 2005 xml searching

am 16.04.2008 12:22:38 von Nick Chan

thanks a lot !!
On Apr 16, 4:57=A0pm, "rote" wrote:
> nick post it to the xml newsgroup and u will get a prompt reply
>
> "nick chan" wrote in message
>
> news:ca4e2830-ae06-4b9c-8dfc-9592634e4e97@s13g2000prd.google groups.com...
>
> > 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?
>
> > -------
> > Select * from Table Where (XMLColumn contains attribute of id=3D"2" and
> > value like "y%")