How do i query a specific xml node within sql server 2005?

[greengo]

I am trying to query a node\[code\]<report><queries><selection><dataItem><expression>\[/code\]from a cognos report definition, which is stored in an xml field in a sql server table. this is what the start of the xml looks like;\[code\]<report xmlns="http://developer.cognos.com/schemas/report/7.0/" useStyleVersion="10" expressionLocale="en"> <modelPath>/content/package[@name='Rental_POC']/model[@name='model']</modelPath> <drillBehavior modelBasedDrillThru="true" /> <queries><query name="Query Revenue"> <source> <model /> </source> <selection> <dataItem name="Equipment type Description" aggregate="none" rollupAggregate="none"> <expression>[BUSINESS_LAYER].[Dim_Equipment_Item].[Equipment type Description]</expression>\[/code\]I am strugling with this for days, any help is much appriciated.