SyntaxFix
Write A Post
Hire A Developer
Questions
I came up with a simple work around below which is easy to remember too :-)
select * from (select cast (xmlCol as varchar(max)) texty from myTable (NOLOCK) ) a where texty like '%MySearchText%'