Query Example 2

You can combine multiple Expressions with the AND operator to search multiple columns. The following example illustrates this, and also demonstrates the use of the Includes operator.

TYPE == joint && SURFACE Includes rough

1. Select Query Data from the toolbar or the Analysis menu.

2. Create the Expression TYPE == joint (see Query Example 1 for details).

3. Select the Expression button.

4. Select the AND button.

5. Create the Expression SURFACE Includes rough.

6. Select the Expression button.

7. Select OK.

For the example.dip file, this query should create a new file with 13 rows.

• Note that all entries in the TYPE column are "joint".

• Note that all entries in the SURFACE column "include" the string "rough" – "sl.rough", "rough" and "v.rough". This demonstrates the use of the "Includes" operator, which finds all entries "including" the substring entered as Operand in the Expression.