help with multiple BETWEEN statements

From: Yvonne G <hlngus_at_hotmail.com>
Date: 12 Jan 2003 08:42:28 -0800
Message-ID: <d999b872.0301120842.66c00282@posting.google.com>

Can someone provide an assist with compound BETWEEN syntax?

I want to enforce the following:

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

etc, etc.

What is the proper syntax?

Thanks. Received on Sun Jan 12 2003 - 10:42:28 CST