Re: ORDER BY distance from a point

Scott Gifford wrote: Hello, I'd like to sort my query results based on their distance from a given point. The actual data I have will be in (longitude,latitude) format, but I can convert to something else if that will work better. For example, I may have data like this Item

Re: ORDER BY distance from a point

Scott Gifford <[EMAIL PROTECTED]> wrote on 08/24/2005 04:45:36 PM: > Hello, > > I'd like to sort my query results based on their distance from a given > point. The actual data I have will be in (longitude,latitude) format, > but I can convert to something else if that will work better. > > For

ORDER BY distance from a point

Hello, I'd like to sort my query results based on their distance from a given point. The actual data I have will be in (longitude,latitude) format, but I can convert to something else if that will work better. For example, I may have data like this Item Latitude Longitude