Wasp Barcode Inventory Control - Manual (Page 304)

InventoryControl Printable Help
 Operator is a comparison operator used to evaluate an expression.
Comparison Operator Meaning
= equal
<> not equal
>= greater than or equal
> greater than
<= less than or equal
< less than
Like is similar to value
Not Like is not similar to value
Is Null no value
Is Not Null any value
 Like and Not Like are used for text pattern matching. They can only be used with plain
text fields, not with dates. The following characters, used within the text value, have a
special meaning for the Like and Not Like operators:
LIKE Operator Meaning Examples
_ (underscore) matches any
single
character
LIKE '_-inch' matches
'2-inch', '3-inch', etc.
% matches zero
or more
characters of
any value
LIKE 'Eric W%'
matches 'Eric White',
'Eric Williams', etc.
\ Escapes the
special
characters
(gives them
their normal
meaning)
LIKE '\%' matches '%'
LIKE '\\' matches a
single '\'
 Value is the information you are searching for. (This may included special characters for
the Like or Not Like operators).
 Logical is a Boolean operator that combines one or more filter expressions into a single
logical group:
Boolean Operator Meaning
AND gives you the intersection of
two conditions
OR gives you the union of two
conditions
289