|
Operators for advance
searches...
Contains
find records that contain full or
partial word - example - clock finds clock,
grandfather clock, wall clock. Another example -
lock - would find records that contain the words pad lock, door
lock, clock, wall clock and so on.
Does NOT
Contain
find records that DO NOT contain
full or partial word - example - clock
would find all records that DO NOT contain the word clock.
Begins
With
finds all words that Begin with -
example - Item Name Begins with book -
will find all items names that start with book
such as "books, book, bookcase"
Does NOT Begin
With
finds all words that DO
NOT Begin with - example - Item Name Does NOT Begins
with book - will find all items names that do
not start with book such as
"books, book, bookcase" will NOT be found
but an item named "The Book of Maps would be
found.
Is Equal
To
Example when searching for Item
ID 354 only finds the record 354
Is NOT Equal
To
Example when searching for Item
ID 354 only finds ALL records except 354
Is Greater
Than
Example when searching for Cost
$25.00 will find all records that cost more than $25.00 such as $25.01 and
higher.
Is Less
Than
Example when searching for Cost
$25.00 will find all records that cost LESS than $25.00 such as $24.99 and
lower.
Is Greater Than Or
Equal
Example when searching for Cost
$25.00 will find all records that equals $25.00 and all items that
also cost more than $25.00, such as $25.01 and higher
Is Less Than Or
Equal
Example when searching for Cost
$25.00 will find all records that equals $25.00 and all items that
also cost Less than $25.00, $24.99 and
lower