Russ,
   I use this form:
   >select file by-exp qty >= "1000" and <= "2000"
____________________
Antonio Carlos
Departamento TC)cnico
Integral Sistemas
Telefone 11 3205-6000 - Fax 11 3205-6001
www.integral.com.br
______________________________________________________________
GPG signed/encrypted mail welcome.
OpenPGP ID: 0xC1FD2134
Fingerprint: 294C DF90 1648 D58B C279 0C9A 46B9 7DE2 C1FD 2134

   Russ Watson wrote:

 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/

Reply via email to