Here XmlColumn is a comumn of data type xml .Your solution is here.just get is suit for yours and use.If there any problems then please ask.
DECLARE @xml_var XML
select @xml_var=[XmlColumn] from [SubscriberDB].[dbo].[tbl_MyTable]
SELECT
Category.query('./text()')
AS ID
FROM
@xml_var.nodes('/Category/ID')
AS Bike(Category);
OUTPUT:
ID
---
A50
A51
A52
A53