Search in XML with like Keyword

If you want to search in XMl valued that contained that specific string then use this query

SELECT *
FROM table_name
WHERE Col_name.exist('//*/text()[contains(upper-case(.),upper-case("zipcode"))]') = 1 --
in this query i am search zipcode in XML