Tag: xml column

How to search from an XML column in SQL

Search from an xml column in sql 

<ArticlePage>
  <publishDate><![CDATA[201612151611499007]]></publishDate>
  <category><![CDATA[1000004]]></category>
</ArticlePage>

SELECT *
  FROM [Table_Name]
  where CAST([xml] as XML).value ('(/ArticlePage/category)[1]', 'varchar(max)') like '1000004'