Nearby zipcodes from a point

[tasmisr]

Hi,
I have a database of zipcodes,longit ude and latitude. I want to
calculate the nearby zipcodes from a specific zipcode. I have the
function that gives the distance between two zipcodes but I need more
robust way to find the nearby zipcodes without looping and calling my
function for 33,000 records of zipcodes.

here is the function I used to get the distance between two zips:
(sql2000 server user defined function)

CREATE FUNCTION dbo.fn_CalcMile s( @LatA FLOAT , @LongA FLOAT , @LatB
FLOAT ,@LongB FLOAT )

RETURNS FLOAT

AS

BEGIN

DECLARE @localRConst FLOAT
DECLARE @localAns FLOAT
DECLARE @localMiles FLOAT

SET @localRConst = 57.3
SET @localAns = 0
SET @localMiles = 0

IF @LatA IS NULL OR @LatA = 0 OR @LongA IS NULL OR @LongA = 0 OR @LatB
IS
NULL OR @LatB = 0 OR @LongB IS NULL OR @LongB = 0
BEGIN
RETURN ( @localMiles )
END

SET @localAns = SIN(@LatA / @localRConst) * SIN(@LatB / @localRConst)
+
COS(@LatA / @localRConst ) * COS( @LatB / @localRConst ) *
COS(ABS(@LongB -
@LongA )/@localRConst)
SET @localMiles = 3959 * ATAN(SQRT(1 - SQUARE(@localAn s)) / @localAns)

SET @localMiles = CEILING(@localM iles)

RETURN ( @localMiles )

END