I have a table with 2 columns, first column called ObjectID - GUID field with Primary INdex, then a field called xmlData that is XML data type.
I want to get all ObjectIDs where certain xpath criteria matches the data in the xmlData field
here's what I have so far for the query, but it keeps returning data even if the xPath does not match
for $data in //xml/data
where $data/@value < "5"
View Complete Post