Wild Cards shortcuts in Enterprise ERP

Symbol

Description

Example

= or ==

Use to find records that are equal to the value typed in the box

=ME in the State field finds records where the value equals ME.

<

Use to find records with a value less than the data typed in the field

<L finds data A-K

<=

Use to find records with a value less than or equal to the data typed in the field

<=L finds data A-L

>

Use to find records with a value greater than the data typed in the field

>L finds M-Z

>=

Use to find records with a greater than or equal to the data typed in the field

>L= finds L-Z

<> or !=

Use to find records with values not equal to the data typed in the field

<>1 finds all records where the value is not equal to 1

: or ..

Use to find records based on a range of data between and including two limiting characters

1000:1400 in the Fund filed, finds all accounts in all funds between and including 1000 & 1400

|

Use to find records with this value or that value

51000|52000 in the Object fields finds all counts with the Object codes 51000 & 52000

*

Use to find all records with the same sequential character strings that begins, includes, or ends with an asterisk(*)

ARL* finds all records starting with ARL, such as Arlington; *H finds all records ending with H such as Smith, Worth

?

Use to find all records with the same sequential character string where only a single-character differs

A?C finds all records where the value equals ABC, ADC, ACC, AEC, and so on.