You can use methods like EXISTSNODE on the XML type to check for existence of nodes matching an XPath expression:
SELECT customerID
FROM customer
WHERE customerxml.EXISTSNODE('/Customer/Name', '') = 1;
The query result is:
customerID ----------- 1
You can use methods like EXISTSNODE on the XML type to check for existence of nodes matching an XPath expression:
SELECT customerID
FROM customer
WHERE customerxml.EXISTSNODE('/Customer/Name', '') = 1;
The query result is:
customerID ----------- 1