Is there any way that an xml column in sql can be made to not be case sensitive?
So you can search for the text() of a node matching say 'open' (properties.exist('property[. = "open"]') and get all results back where the property text = "OPEN" or any other not case sensitive combination of "open".
Collations are not supported in SQL Server 2005 for XQuery. In order to perform your collation-sensitive comparison, you should promote the value out of the XML instance using the .value() method and perform the comparison in T-SQL.|||
If you find that you like to see such functionality added in a future release, please file a request in the SQL Server Feedback Center @. http://lab.msdn.microsoft.com/productfeedback/
Best regards
Michael
No comments:
Post a Comment