IN Clause

A field can be tested for membership in a set of values using the IN clause. Examples:

EventID IN (512,1024,2048,4096,8192,16384,32768,65536)

LastName IN (Jones, Smi*, Vledick)

As shown, values are enclosed in parentheses and separated by commas. String values can use wildcards. Literals that are not a simple term must be enclosed in single or double quotes. The IN clause is a shorthand for a series of OR clauses. For example, the following clause:

LastName IN (Jones, Smi*, Vledick)

is the same as the following OR clauses:

LastName = Jones OR LastName = Smi* OR LastName = Vledick

As a synonym for the IN keyword, Doradus also allows the syntax field=(list). For example, the following two clauses are equivalent:

LastName IN (Jones, Smi*, Vledick)

LastName=(Jones, Smi*, Vledick)