Russ
RetrieVe doesn't have BETWEEN but SQL does, so for clarity you can use this
form:
SELECT @ID TO SLIST 0 FROM yourfile WHERE (qty BETWEEN 1000 AND 2000);
One of those rare times SQL is more helpful...
If you're listing, rather than selecting, you can use RetrieVe substituting the
WHEN clause, but that won't help you here.
Brian
I want to select records to report if *one* of the multivalues falls
within a range.
For example: select with qty >= 1000 and =< 2000
If I use the example I get records where none of the values satisfies
the range condition.
@ID qty
--- ---
1129 2,500.0
2,500.0
300.0
Russ
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
