Posted by John on 04/26/06 19:53

The XML Datatype does not support the case-insensitive search makes the
XML DataType (almost) useless, if I stored the xml in the XML column, I
certainly want to search it, if I could not performance
case-insensitive search, why do I need store the data in the XML
column?

I try the following:

1) The fulltext search will not tell you which element has the match

2) Using Nodes cross Apply, I got the following error:
The column 'x' that was returned from the nodes() method cannot be used
directly. It can only be used with one of the four XML datatype methods
exist(), nodes(), query(), and value() or in IS NULL and IS NOT NULL
checks.

Very frustrated!!!

Any Suggestions & Advice?
Thanks in advance.
John

[Back to original message]