>This is likely related to your latitude, longitude question in SQL server. If so, again I would use MSSQL's spatial data methods. ie:
>
>

DECLARE @g geography;
>SET @g1 = geography::STGeomFromText('POINT(-65.7142 47.7661)', 4326); --Petit-Rocher nord
>SET @g2 = geography::STGeomFromText('POINT(-65.7305 47.7975)', 4326); --Petit-Rocher sud
>
>select @g1.STDistance(@g2);
>
>SELECT @g1.STBuffer(3700).STIntersects(@g2); -- true, within 3700 meters

Cetin

I will have to take a look at this later on. I would need to check if this can apply and if the performance is as good.