|
Posted by John on 04/26/06 19:08
Hilary Cotter wrote:
> Full-text index it and search it that way.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "John" <johnxhc@yahoo.com> wrote in message
> news:1145989595.653856.252350@e56g2000cwe.googlegroups.com...
> > Does anyone know how to how to performance case-insensitive search on
> > XML data type in SQLServer 2005? Or I have to convert all the xml data
> > to lower case before I store it?
> > Thanks in advance.
> > John
> >
what if I want to find it peticular element in the XML column contain
that text or not ?(again it has to be case-insensitive)
Thanks.
Navigation:
[Reply to this message]
|