SQLServerCentral » Latest topics
Finding a string in XML column using sql server
1. I have a table with a xml column.
2. I require to search for sub string in that xml column for all its node and value. Search should be case insensitive
3. Structure of XML in each row is different
I used below query to do that,
2. I require to search for sub string in that xml column for all its node and value. Search should be case insensitive
3. Structure of XML in each row is different
I used below query to do that,
No comments:
Post a Comment