Steven Willis (7/15/2013)
Here's a stored procedure that calls the Google geocoding service which will work on full address or a zip code (center of zone) returning the lat/lon for the location. The second procedure lets you enter an origin and destination address (or zip) and returns the miles between the two points based on the lat/lon returned by the first procedure.
Haven't tried it but very cool. That bad boy just found a home in my briefcase. Thanks, Steven.
--Jeff Moden
Change is inevitable... Change for the better is not.