Report question

Question: SQL Server 2008 XML Query method - retrieve text() value where another text() value exists?