Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...