Posted by Hilary Cotter on 04/25/06 21:39

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
>

[Back to original message]