SQL SERVER 2005:
---------------------------
I have a table containing US zipcodes, longitude, latitude. Using sql server 2005 geographical location data type can I get the zipcodes that are at a particular distance from my given zipcode.
Example:
I want to get zipcodes that are 10 miles from zipcode 10001 (NYC)

Well, for starters, geospatial data types were introduced in SQL Server 2008. So if you're using 2005, you'll need to come up with another solution. If you opt for 08, here's some reading that will help you understand how to make use of the goedata.

http://en.wikibooks.org/wiki/Geospat..._in_SQL_Server
http://msdn.microsoft.com/en-gb/libr...(SQL.100).aspx

can you use the google maps api? thats what i use to get address from postcodes

He's asking how to know if 94831 and 94209 are within 10 miles of each other or not. I don't know if the Google API does this? SQL Server does, inherently, and a great deal more. In database semantics, which means you can ask it for a list of all places it knows about within a radius, and any number of other queries. But only starting with SQL Server 2008, so if our friend has 2005, some other API will be needed.