>I have a need to see if a value falls into several possible ranges. is used the following code:
>inrange = Inlist(.T.,between(chkval,1.75,2.0),between(chkval,2.8,3.2),(etc.) )
>
>It works and is pretty easy to read. I read that you shouldn't use IIF (or inlist) in an SQL Select. Is there another way to do this?
WHERE (ChkVal BETWEEN 1.75 AND 2.0) OR (ChkVal BETWEEN 2.8 AND 3.2)