Drillhole Import Wizard - Filter Conditions (SQL Builder)

Summary

Use this dialog to specify conditions to enable you to filter out unwanted rows. When importing fields (columns) from an external database into the current geodatabase feature dataset, you may only want certain rows to be imported.

Usage / Condition Syntax

Wildcards (%) can be used with string fields. For example to select only Collar IDs that start with "AX" you would specify, "equals AX%".

When using the "between" filter condition you must specify your two numbers separated by a comma for example, "between 10,19".

Conditions applied to the same field should apply the logical OR. Conditions applied to different fields should apply the logical AND.

Parameter	Explanation
Field	Select one or more field(s) for which you want to define a condition on which to filter.
Condition	Specify a condition type for the field(s). Your choices are: equals does not equal less than greater than less than or equal to greater than or equal to between
Value	Specify the value(s) against which to compare the field(s).

Parameter

Explanation

Field

Select one or more field(s) for which you want to define a condition on which to filter.

Condition

Specify a condition type for the field(s). Your choices are:

equals
does not equal
less than
greater than
less than or equal to
greater than or equal to
between

Value

Specify the value(s) against which to compare the field(s).