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/