Re: negation of range

[pedro.reis@xxxxxxxxx]

yes, I thought resolving this problem whith that kind of solution,  but if
i could resolve it whit one operator ...



Paul nelson wrote:

Come to think of it, if you want to do some extra work, you could create 3
queries:

1. Send to an outfile the data where the value is less than the lower range
value.
2. Send to that same outfile the data where the value is greater than the
upper range value.
3. Produce your report over the new outfile. You would, of course, delete
the outfile at the end.






Cordialement,
Best regards,
-------------------------------------------------------------------
Pedro Reis
e-mail: pedro.reis@valeo.com
Phone: 351-258 350 725
Fax: 351-258 350060
--------------------------------------------------------------------
VALEO - Electronics & Connective Systems
Viana do Castelo - Portugal
--------------------------------------------------------------------

"This e-mail message is intended only for the use of the named
recipient(s).
The information contained therein may be confidential or privileged, and
its
disclosure or reproduction is strictly prohibited. If you are not the named
recipient, please return it immediately to its sender at the above address
and destroy it."