CODEWITHSUNDEEP
xquery
SnoopyMe
SnoopyMe

Reputation: 1035

Is there an equivalent to SQL's IN clause in XQuery?

Is there anything like the SQL IN clause in XQuery? E.g., I want to do something like this:

where  $x/lotClosedYn in ('Y','N')

using IN keyword is giving an error, I am using saxon for XQuery processing.

Upvotes: 7

Views: 4103

Answers (1)

Jens Erat
Jens Erat

Reputation: 38732

Use =. It works set-based, so ("Y", "A", "B", "C") = ("Y") returns true.

Upvotes: 13

Related Questions