468,301 Members | 1,430 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

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

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
2 2080
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

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.

Similar topics

25 posts views Thread by Brian Patterson | last post: by
31 posts views Thread by Roland Hall | last post: by
reply views Thread by Bryan Parkoff | last post: by
6 posts views Thread by Scott CM | last post: by
6 posts views Thread by pragile | last post: by
6 posts views Thread by RepStat | last post: by
2 posts views Thread by Stephan Rose | last post: by
10 posts views Thread by =?Utf-8?B?Um95?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.