by "Plamen Ratchev" <Plamen@[EMAIL PROTECTED]
>
Apr 16, 2008 at 10:28 AM
Here is one way:
SELECT keycol, datacol
FROM Foo
WHERE datacol.exist('/details/attribute[@[EMAIL PROTECTED]
= "2"]') = 1
AND datacol.exist('/details/attribute[substring(@[EMAIL PROTECTED]
1, 1) = "y"]')
=
1;
HTH,
Plamen Ratchev
http://www.SQLStudio.com
