Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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?