Guys To return to my earlier post:
WHEN is an output limiter. It limits the output of values, so it will work if you want to LIST those records by suppressing the output of the individual values that don't match. But it won't work in a SELECT in this case, unless you are already exploding, since the select will still vector each half of the test independently. Sadly, RetrieVe doesn't support BETWEEN - but SQL does. And it can generate a select list, so you can use that. SELECT @ID TO SLIST 0 WHERE (QTY BETWEEN 1000 AND 2000); >> nn records selected (Why does nobody ever use the SQL in UniVerse? <sigh> It's not like using it in Oracle you know...) Brian ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
