KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
If you have a varchar field you can easily do SELECT * FROM TABLE WHERE ColumnA LIKE '%Test%' to see if that column contains a certain string. How do you do that for XML Type? I have the following which returns only rows that have a 'Text' node but I need to search within that node select * from WebPageContent where data.exist('/PageContent/Text') = 1
Tags (comma-separated)
Save Edits
Cancel