Selecting Nearby Distinct City/zipcode Issue

I have the following code, which returns a list of nearby cities based on a city name as input. Most cities have multiple zipcodes per city name, thus it can list multiple rows with the same city name, but with different zipcodes like below:





Zip | Cityname


111 belmont


112 belmont


113 belmont


114 san francisco


115 san francisco





---------------- etc----------------





I do not really care about each group of zipcodes. I only need one pair of zipcode/city name like the following:





ZIP | City name


111 belmont


114 San Francisco








How do I change my select to only return a distinct city name. I do not care which if the city/zipcodes it returns from the similar city.





The select statement is below:














CREATE PROCEDURE ZipSearchByCity


@city varchar(40),


@State varchar(5),


@distance int








AS








SELECT distinct o.City AS City, o.zip_code, o.State AS State,


(3956 * (2 * ASIN(SQRT(


POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +


COS(z.RADlatitude) *


COS(o.RADlatitude) *


POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)


)))) dist





FROM zipcodes z,


zipcodes o,


zipcodes a














WHERE z.city = @city AND


z.State = @State AND


z.zip_code=a.zip_code AND


(3956 * (2 * ASIN(SQRT(


POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +


COS(z.RADlatitude) *


COS(o.RADlatitude) *


POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)


)))) < @distance


GO

















Thanks,





Christian