On May 19, 2006, at 8:34 PM, Ronald Anderson wrote:

> Is there a way using SELECT to select a number that is for instance  
> anywhere from 1 to 3 or anywhere from 7 to 9?

SELECT n
  CASE 1, 2, 3
  CASE 4, 5, 6
  CASE 7, 8, 9
END SELECT

or--

SELECT n
  CASE < 4
  CASE < 7
  CASE ELSE
END SELECT

See my last msg for a more efficient way of dealing with this.

   e-e
   =J= a  y
    "