Using Boolean Expressions

You can specify Boolean expressions in the subqueries in filters. You specify the Boolean AND, OR, and NOT operators like this:

and

or

not

You can use parentheses to group collection specifications and operators for clarity or where the normal precedence is inadequate to express an operation.

Case Sensitivity

Operators are case sensitive. Spaces are not significant. You can omit them or include them for clarity.

Examples

The following query returns all authors who have at least one degree and one award:


author[degree and award]

The next query finds all authors who have at least one degree or award and at least one publication:


author[(degree or award) and publication]

Following is a query that finds all authors who have at least one degree and no publications:


author[degree and not(publication)]

< Previous | Next >

Electronic Data Interchange (EDI) Blog

The EDI-L Blog is the best technical forum for discussing topics related to Electronic Data Interchange (EDI), including EDIFACT, and X12 Technologies. Topics include EDI Software, EDI Standards, EDI applications, EDI examples, and more.

Sybase

Sybase Adaptive Server Enterprise (ASE) is a powerful high-performance database for recording and retrieving business records. Learn how to develop XML applications for Sybase using Stylus Studio.

XML Whitepaper

Learn how XML can help you meet your business objectives by reading free XML Whitepapers covering XML, XML Schema, XQuery, SQL/XML, and FIXML technolgies employed in real world case studies.