Case insensitivity can also be combined with the wildcard symbols (*) and (?).

Examples:
~1A4?3B
~customer*
~Fr*21?3

Note: If a value you want to search for contains one of the reserved search symbols, then prefix the value with the equal operator. For example, if you want to search for 101A-208B<D,C,then enter =101A-208B<D,C to get an exact match. With the (=) in front, the (<), (-) and (,) will be treated as regular characters.

Note: For a search expression like ABC..01*DEF-99, a wildcard operation would be performed because the (*) has higher precedence than the (..) and the (-).

Note:When using an Oracle database, the multiple wildcard character is automatically replaced with the Not Equal To (<>) search operator. If you want to also retrieve records for which the field value is null, do one of these:

• Leave the criteria blank;
• Use *+null; or,
• Use <>+null.

In addition, returns the opposite value of the search symbol used. For example, !10:20 returns any values not between 10 and 20.

Examples:
!order;01;dirbl;notes (when entered in the 'Shipping Document Number' field in SU45/I1, as an example, will search for ALL Back Orders)
!case,tare,pallet (not in list)
 !TAX* (not like)
!a..b (not in range)

Theoretically, all existing operators can be negated; however, the following already have an equivalent:

• If the operator is <=a (less than or equal to), then to negate it, we would enter !<=a (not less than or equal to) or its equivalent, >a (greater than).
• If the operator is <> (is not null), then to negate it, we would enter !<> (not is not null) or its equivalent , = (is null).

Note: ! is not the same as <>. ! means not, whereas <> means different than or not equal to. != is the same as <>.

Note: !a means not a, which is the same as <>a; this only works when you have a single value.

Math Operator: (+|-). Add or subtract the quantifier.

Quantifier: (0-9). Numeric that will be used in conjunction with the math operator and the qualifier to add or subtract a certain amount of time.

Qualifier: (hour|day|week|month|year). Hour or day or week or month or year. Day is default.

Note: If no qualifier is specified, the default is taken.

Post Instruction: (hour, day, week, month, and year).

Math Operator: (+|-). Add or subtract the quantifier.

Quantifier: (0-9). Number of hours, days, weeks, months or years to add or subtract. When a post instruction is specified, it uses the post instruction as the qualifier.

Qualifier: (hour|day|week|month|year). Hour or day or week or month or year. Default is day. Not valid when a post instruction is specified. The system will take the post instruction and use that as the qualifier.

Examples:

{session.user}; tecsys: current user or user tecsys
<>{session.user}: anyone but the current user

Example:

A new view is created from the INIDP table (Invoice History Detail Product) that contains the search criteria fields 'Domestic Line Extension' and 'SA Cost of Sales Dollars'.

To find all of the customer invoice records for which the Domestic Line Extension is less than the SA Cost of Sales Dollars, enter the following criteria in the Domestic Line Extension field of the view:

<{column.inidp.sacos}

The expression is always preceded by a search operator, in this case the less than sign '<'. The information inside the brackets indicates the column value that the search is being performed against. The first portion of the value is always 'column'. This is followed by the table and column name. Each value is separated by a period and must be enclosed in the curly brackets.

Table and column names can be found in the meta_md_column view.