Re: help with multiple BETWEEN statements

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Mon, 13 Jan 2003 18:42:40 GMT
Message-ID: <AMDU9.30$E91.3275026@newssvr15.news.prodigy.com>

Yvonne G wrote:
> Thanks for the input; I've tried putting liberal parentheses as per
> the following snippet, to no avail:
>
> AND ADORDER.TYPE = 'C' AND
> ((((RUNINS.CLASS) Between ' 105' And ' 820'))
> OR (((RUNINS.CLASS) Between '4010' And '4320')))
>
> Anyone have additional suggestions?

You certainly did use liberal parens! You should do very well editing tnsnames.ora files! :)

BTW, what *does* happen to make you say "to no avail"? Error messages? Wrong set of data?

If runins.class is a varchar2, then wouldn't you look for '105' and '820'? If it's a char, you'd look for '105 ' and '820 '. Of course, you could have stored it the way you've indicated, in which case you have another problem. Received on Mon Jan 13 2003 - 12:42:40 CST