Conditional Search Functions

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'

Notes

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.