Select distinct v.value('./@Sep', 'varchar(255)') Sep FROM Formats CROSS APPLY Data.nodes('//*[@Sep]') TempXML(v) where v.value('./@Sep', 'varchar(255)') like '%\%'