sql case       

##sql case语句

  (a.Orderer = {1} or case  when a.Visibility > 2  then ( ISNULL({0}) or (a.Visibility & {0})>0 )
	else  (a.Visibility & {0})>0 end )
	
	
	case when distance < 5 then 0 when distance < 10  then 1 when distance < 20  then 2 " +
				" else  3 end,