we did something like this a while back.
i remember we AND'ed what you basically have now with a number of less than and
greater than expressions to "box" the circle that you describe in your statement.
this "boxing" of the area merely provided a way to quickly limit the number of rows
against
On Fri, 27 Dec 2002 13:11:42 -0500, Asendorf, John wrote:
>SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
>Distance
>FROM Dealers
>INNER JOIN Zips ON Dealers.Zip = Zips.Zip
>ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2)
Off the top of my head have
