Select XML values when attribute involved I have a table that stores XML values in field: OtherData. 

An XML value from one row: 

&lt; file path="C:\WINDOWS\system32\svchost.exe" /&gt;


I would like to select all rows that have an attribute path like '%svchost%'

What is the right SQL query to do this?
Use the XQuery CONTAINS method, like this:

SELECT CASE @x.exist
(
N'/bikes/Product[1]/Specifications[contains(., "Novice")]'
)
WHEN 1 THEN N'The bike is good for novices'
WHEN 0 THEN N'The bike is for more advanced riders'
END;


Good luck.