It's been a super long time since I used WHEN, but now that you mention it, I remember doing that a long long time ago in a galaxy far far away :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Wednesday, December 19, 2007 16:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2] selection of multivalued field based on range Actually, WHEN works for a normal list as well. If you have multiple associated multi-valued fields, you can restrict which multivalues display using WHEN. For example: LIST ORDERS ITEM QTY PRICE WHEN QTY GT 10 Assuming ITEM, QTY and PRICE are associated, the result will only show those lines whose quantity is greater than 10. To answer Russ's original question: I don't think UniVerse supports BETWEEN, but the following may work (it works in UniData): SELECT FILE WITH ANY QTY >= 1000 AND WITH ANY QTY <= 2000 The ANY keyword examines each value independently. If you use WITH QTY >= ... Then the entire QTY attribute (which may look like 2500}2500}300) is evaluated. HTH Larry Hiscock Western Computer Services ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
