>Steve,
>
>Tore already gave you the answer. I'd also add that write the expression like you'd see in an algebra text ( 10 < a < 15 ) in a SQL statement won't fully optimize:
>
>

>select sum(b) ;
>   from x ;
>   where 10 < a and a < 15
>

>
>10 < a won't optimize because the field is on the right hand side of the operator. a > 10 will optimize.

Thanks for reminding me... would you know whether a " a Between 10.01 and 14.99" would optimize?