Wasp-barcode Inventory Control Manual de usuario Pagina 304

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 518
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 303
InventoryControl Printable Help
Opera
tor 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
Vista de pagina 303
1 2 ... 299 300 301 302 303 304 305 306 307 308 309 ... 517 518

Comentarios a estos manuales

Sin comentarios