How about SELECT WITH QTY >= 1000 AND WITH QTY <= 2000?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
"Russ Watson" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2007 09:37 AM
Please respond to u2-users
To: <u2-users@listserver.u2ug.org>
cc:
Subject: [U2] selection of multivalued field based on range
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/
This email was Anti Virus checked by Astaro Security Gateway.
http://www.astaro.com
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
