XPath query that gets elements whose subelements have an attribute with a particular value

[Novice]

Hi all, I'm having some trouble with a XPath query I would like to make

I have the following simplified XML
<A><B><C name="Test"></C><C name="Test2"></C></B><B><C name="Test"></C></B></A

I would like to return all B elements that have a C sub-element that have a name with a particular value

For example - I would like to retrieve all B elements that have a C sub-element with a name of Test. This should return 2 B elements. Likewise, if I wanted all B elements with a sub-element C with the name "Test2" I would get only one B element

I've tried various strings, but nothing seems to work - for example the following won't do it
/A/B[@C/name = 'Test'
/A/B[C@name = 'Test'

Is there an intersection query I could use to create this query

Thanks
Novice

[solex]

Here you go:
/A/B[C/@name = 'Test']
"Novice" <6tc1ATqlinkDOT queensuDOTca> wrote in message
news:A5******** *************** ***********@mic rosoft.com...

Hi all, I'm having some trouble with a XPath query I would like to make:

I have the following simplified XML:
<A><B><C name="Test"></C><C name="Test2"></C></B><B><C name="Test"></C></B></A>
I would like to return all B elements that have a C sub-element that have a name with a particular value.
For example - I would like to retrieve all B elements that have a C sub-element with a name of Test. This should return 2 B elements.
Likewise, if I wanted all B elements with a sub-element C with the name
"Test2" I would get only one B element.
I've tried various strings, but nothing seems to work - for example the following won't do it: /A/B[@C/name = 'Test']
/A/B[C@name = 'Test']

Is there an intersection query I could use to create this query?

Thanks,
Novice