<vehicle> <sedan> <type color="red" make="honda" year="2019"> <dealers> <dealer address="1234 Cat Drive"> <dealer address="1944 Dog Drive"> </dealers> </type> </sedan> </vehicle>
1234 Cat Drive
SELECT Vehicles.query('/vehicles/sedan/type/dealers/dealer[@address="1944 Dog Drive"]')
DECLARE @AddressToFind nvarchar(100) = N'1234 Cat Drive'; SELECT Vehicle, OtherColumns FROM YourTable WHERE Vehicle.exist('//dealer[@address = sql:variable("@AddressToFind")]') = 1 ;
query
nodes
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)