Question: how to extract data from xml file in sql server?
Answer: Query: SELECT * FROM [Table name] WHERE [xmlBody]. value('(/Data/ProductID/System)[1]', 'varchar(max)') LIKE 'CAL-ATK-01B-01'; I need to select all records with matching value in xml file as "CAL-ATK-01B-01" .