SELECT FormatID, Name, Description ,v.query('.') FontNode ,v.query('..') ParentNode ,v.value('@Token', 'varchar(100)') AS TokenText ,v.value('@Justify', 'varchar(100)') AS Justify FROM Formats CROSS APPLY Data.nodes('//Item') TempXML(v) where v.value('@Token', 'varchar(100)') like '%{PAGE}%'