Re: help with multiple BETWEEN statements

I think you mean the following:

         SELECT A  from table1
          where rate = 'abc'
         or     code between '0100' and '0199'
         or     code between '4000' and '4499'
         or     code between '7000' and '7999'
         or     code between '9000' and '9499';

Xho is correct in the fact that you can't stisfy mutually exclusive conditions.

Cliff Received on Sun Jan 12 2003 - 17:50:12 CST