By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

How to performance case-insensitive search on XML data type in SQLServer 2005?

P: n/a
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

Apr 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <jo*****@yahoo.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.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

Apr 25 '06 #2

P: n/a

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" <jo*****@yahoo.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.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.

Apr 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.