>>

>>CREATE FUNCTION [dbo].[CalculateDistance]
>>    (@Longitude1 DECIMAL(8,5), 
>>    @Latitude1   DECIMAL(8,5),
>>    @Longitude2  DECIMAL(8,5),
>>    @Latitude2   DECIMAL(8,5))
>>RETURNS FLOAT
>>AS
>>BEGIN
>>DECLARE @Temp FLOAT
>> 
>>SET @Temp = SIN(@Latitude1/57.2957795130823) * SIN(@Latitude2/57.2957795130823) +
>> COS(@Latitude1/57.2957795130823) * COS(@Latitude2/57.2957795130823) * COS(@Longitude2/57.2957795130823 - @Longitude1/57.2957795130823)
>> 
>>IF @Temp > 1 
>>    SET @Temp = 1
>>ELSE IF @Temp < -1
>>    SET @Temp = -1
>> 
>>RETURN (3958.75586574 * ACOS(@Temp) ) 
>> 
>>END

>
>I already have the method to calculate the distance between two coordinates. I am trying to find the proper SQL command to return the records matching a certain distance from a set of coordinates.

One more time - read the blog I gave you a reference a couple of times. It has all necessary methods listed including what you're looking for.