>I know.. makes you look crosseyed...:)
>
>I'm green to SQL Server but do you know if you can do something like
>
>select *, iif(q1a >2 ,1,0) as q1a_val ..etc from mytable into cursor q1
>
>select * from q1 where q1a + q1b +q1c + q1d >=2
>
>??
>
>kinda roundabout but would be a little simpler...

this is what i was trying to think of before...

select *
  from mytable
  where (sign(q1a-2.5) + sign(q1b-2.5) + sign(q1c-2.5) + sign(q1d-2.5) >= 0
      or sign(q2a-2.5) + sign(q2b-2.5) + sign(q2c-2.5) + sign(q2d-2.5) >= 0)

works in both vfp and sql server, too