Xpath equivalent to select in for sql server??

[Shay1975]

What I am trying to do is filter on some attributes and I could have a
list of values, so instead of doing where attribute = value or
attribute = value, I am wondering if there is something equivalent to
the IN statement in sql, so attribute in (value1, value2) etc..

Thanks

[Martin Honnen]

Shay1975 wrote:

What I am trying to do is filter on some attributes and I could have a
list of values, so instead of doing where attribute = value or
attribute = value, I am wondering if there is something equivalent to
the IN statement in sql, so attribute in (value1, value2) etc..

XPath 2.0 allows e.g.
attribute = ('value1', 'value2', 'value3')
but with XPath 1.0 (which .NET 1.x and 2.0 support) you have to use or
expressions
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Sergey Dubinets]

In XPath operator = works similar way when arguments are node-set.
So if you can express the set of your values as node-set you can use
operator = as 'IN'.
This is quite easy to do in XSLT you can produce such node-set from RTF or
from XML fragment imbedded into stylesheet as top level element.

Sergey

"Shay1975" <sh**************@gmail.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...

What I am trying to do is filter on some attributes and I could have a
list of values, so instead of doing where attribute = value or
attribute = value, I am wondering if there is something equivalent to
the IN statement in sql, so attribute in (value1, value2) etc..

Thanks