>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.