Try this. It is a slight modification to the query posted by AmitGajjar
SELECT
x.y.value( 'Name[1]', 'NVARCHAR(20)' ) AS Name,
x.y.value( 'Color[1]', 'NVARCHAR(20)' ) AS Color,
REPLACE(REPLACE(CAST (x.y.query( 'Detail[1]') AS NVARCHAR(50)), '<detail>',''),'</detail>','')
FROM @x.nodes('cars/car') x(y)
Hope this helps.