Jeff Does this help: http://www.jassing.com/zipcode/SourceCode.htm & http://www.personnelware.com/zipcode/zipcodecode.html
Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program jeff wrote:
I'm up now I have this for my SQL Server: CREATE PROCEDURE zip_nearby_locations @lat1 float, @long1 float, @radius float AS SELECT (2*3956*ASIN( (SQRT( POWER(SIN((([EMAIL PROTECTED]))/2),2) + COS(@lat1) * COS(rlat) * POWER(SIN(((abs(rlong)[EMAIL PROTECTED]))/2),2) )) ) ) AS dist, location, zipcode FROM Zipcodes WHERE (2*3956*ASIN( (SQRT( POWER(SIN((([EMAIL PROTECTED]))/2),2) + COS(@lat1) * COS(rlat) * POWER(SIN(((abs(rlong)[EMAIL PROTECTED]))/2),2) )) ) ) < @radius ORDER BY dist GO But I was wondering how to do this in VFP At 01:58 AM 8/2/2006, you wrote:And I worry that I drink to much caffeine! -- Michael Hawksworth Visual Fox Solutions [EMAIL PROTECTED] www.foxpro.co.uk
[excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
