>>The where clause restricts to distances < = 250 km - that clause calculates the distance
>>
>>So I would add a select item
>>

>> 3958.75586574*ACOS(CASE WHEN Temp > 1 THEN 1 WHEN Temp < -1 THEN -1 ELSE Temp END)  as Distance
>>

>
>Thanks, this works.


Thought I would