InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 07:14:49 GMT20http://www.sqlservercentral.com/Forums/Topic402330-609-1.aspxHi ScottA nice approach - although I do this in my application server when querying with LINQ rather than on the database. Of course sometimes that is not practical (Like when searching large volumes of data), so having this as a backup is very usefulWhat I did do for my function (and recommend that you do for yours :-) ) is to include in the name what measurement unit it is in - the difference between functions that return values in Miles and those that return values in Kilometres comes up all over the show in bug reports. So I would call it "fn_latlondistance_mi"Regards,JoonWed, 22 Jul 2009 02:07:41 GMTjdurandthttp://www.sqlservercentral.com/Forums/Topic402330-609-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31679/">Calculate distance between two points</A>[/B]Mon, 24 Sep 2007 20:30:56 GMTScott Coleman