The following table defines conditional functions used mainly for configuring Jobs that import or export data.
| Condition | Description | Syntax | Example: |
| = | Equal to | Alphanumeric string, no wildcards accepted | customer_cd = 123456 |
| <> | Not equal to (less than or greater than) | Alphanumeric string, no wildcards accepted | order_shipping <> 0.00 |
| LIKE | Syntax contains | Alphanumeric search string, wildcards required | %description% |
| NOT LIKE | Syntax doesn't contain | Alphanumeric search string, wildcards required | %description% |
| < | Less than | Numeric, no wildcards accepted | 123456 |
| <= | Less than or equal to | Numeric, no wildcards accepted | 123456 |
| > | Greater than | Numeric, no wildcards accepted | 123456 |
| >= | Greater than or equal to | Numeric, no wildcards accepted | 123456 |
| IS NULL | Field/ attribute is empty | No value required | N/A |
| IS NOT NULL | Field/ attribute isn't empty | No value required | N/A |
| IN | Contained in | List of values enclosed in apostrophes and separated by commas, contained in parentheses; or values separated by vertical pipe characters; no wildcards accepted | ('Item1',' item_2') or item_1 | Item2 |
| NOT IN | Not contained in | List of values enclosed in apostrophes and separated by commas, contained in parentheses; or values separated by vertical pipe characters; no wildcards accepted | ('Item1',' item_2') or item_1 | Item2 |
| BETWEEN | Between two values | Datetime or alphanumeric format; two values enclosed in apostrophes and separated by "and" | '6/1/2011' and '12/31/11' |
If a single date is used with BETWEEN or <= and >=, a time must also be specified.
For example:
[Order Date] [BETWEEN] [NULL] ['07/26/2012 12:00AM' and
'07/26/2012 11:59PM']
or
[Order Date] [>=]
[NULL] [07/26/2012 12:00AM]
[Order Date] [<=]
[NULL] [07/26/2012 11:59PM]
When using a condition to specify a date or date range, don't also select a predefined time frame from the drop-down.