Page History
...
Code Block |
---|
srch_strng = "COMPANY_NAME":@VM:"#TRUST INSURANCE":@FM
|
will
...
find
...
all
...
values
...
of
...
the
...
indexed
...
column
...
COMPANY_NAME
...
that
...
are
...
not
...
"TRUST
...
INSURANCE".
...
Searching
...
by
...
BETWEEN
...
Btree.Extract
...
supports
...
a
...
special
...
search
...
operator,
...
between
...
("~"
...
(tilde)).
...
The
...
operator
...
between
...
differs
...
from
...
range
...
in
...
that
...
it
...
is
...
not
...
inclusive.
...
For
...
example,
...
the
...
following
...
search
...
string
...
will
...
return
...
row
...
keys
...
for
...
all
...
rows
...
having
...
ZIP
...
codes
...
between,
...
but
...
not
...
including,
...
98100
...
and
...
98111:
Code Block |
---|
srch_strng = "ZIP":@VM:"98100~98111":@FM |
...
Code Block |
---|
"STATE":@VM:"CT":@FM:"CITY":@VM:";Stamford":@FM
|
Starting,
...
Ending,
...
and
...
Containing
...
The
...
greater
...
than
...
sign
...
(>)
...
and
...
greater
...
than
...
or
...
equal
...
to
...
signs
...
(>=)
...
are
...
valid
...
search
...
string
...
arguments.
...
To
...
extract
...
keys
...
of
...
all
...
rows
...
with
...
City
...
starting
...
with
...
S,
...
code
...
the
...
following
...
search
...
string:
Code Block |
---|
srch_strng = "CITY":@VM:">=S":@FM: "CITY" : @VM @VM : "<T" : @FM |
The
...
"ending
...
with"
...
indicator
...
(])
...
is
...
also
...
a
...
valid
...
search
...
string
...
argument.
...
To
...
extract
...
keys
...
of
...
all
...
rows
...
with
...
City
...
ending
...
with
...
P,
...
code
...
the
...
following
...
search
...
string:
Code Block |
---|
srch_strng = "CITY":@VM:"P]":@FM |
The
...
"containing"
...
indicators
...
([])
...
also
...
are
...
valid
...
search
...
string
...
arguments,
...
allowing
...
for
...
a
...
substring
...
search.
...
To
...
extract
...
keys
...
of
...
all
...
rows
...
with
...
City
...
containing
...
the
...
letter
...
P,
...
code
...
the
...
following
...
search
...
string:
...
Code Block |
---|
srch_strng = "CITY":@VM:"[P]":@FM |
...