Thansk guys

Thanks rbarryyoung , that seems to work really well.

For the sake of my own understanding, can I just ask what the SIN(@Latitude/57.295779513082323) operators are doing in the query, i.e. what...

I am only working with the Continental USA, and only a small portion of that.

Thanks for your help.

Thanks for your ideas guys.

In the end I simply ordered the table by the combined differences between the target latitude and longitude and the latitude and longitudes in the table,...