How to keep between condition for qvd file while loading?

[jagannalla]

Hi,

- I've a qvd file with with fields A,B,C.

- The field A contains the data from 1 to 100.

I written in the script to load A from 20 to 60 like following. But is there any solution to wite in different format to retrive the same result.

Load

A,B,C

from Table.qvd

where A >=20 and A <=60;

[chriscammers]

Sorry there is no "between" opertator like in SQL.

You could use inner join with an intervalmatch load but for what you are doing it would be completeely inefficient and a waste of effort.

What is your objection the the A >=X AND A <= Y syntax anyway?