Need help creating a search for distance
I have a database of over 5 million records all with a longitude and latitude coordinates. I need to enter a known or fixed location's longitude and latitude and get back distance (I already have the formula to find the distance). I have no idea where to start. It would be really cool if I can enter the fixed longitude, latitude and max distance from that fixed point. Example: My fixed point is "A" and I want to return all points with a 1/2 mile from my fixed point "A". Right now I do all my searching in the find mode. I hope this makes sense to someone out there.