Between Function in QV?

[Anonymous]

Hi - is there a way of replicating the between statement in sql when joining tables.

I need to append a value to a field which i can do with an if statement which will look something like

If (A = 1 and B <5000, 100, if(A=1 and B < 10000, 200, and on and on and on

In sql i would just join to a lookup table

FIELD 1 LOWE UPPER  VALUE

A              0        5000     100

and  use the between to return the correct value

Is there a way to do this in the qv load script (the end users of my work won't have oracle access, hence the need to find a QV scripting solution)

Thanks

Nandy

[lironbaram · Accepted solution]

yes there is interval match

the script should look something like :

intervalmatch(B) load lower upper form tbl

that will create a table with every value of b inside his interval

[Anonymous]

Hi, thanks, managed to get something to work just about.