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)