>>

>>DECLARE @g geography,
>>    @area geography ;
>>SET @g = geography::Point(47.7795,-65.7191,4326) ; --Petit-Rocher
>>SET @area = @g.STBuffer(250) ;
>>
>>SELECT  locationId,
>>        Latitude,
>>        Longitude,
>>        @g.STDistance(geoPoint) AS distance
>>FROM    ( SELECT    locationId,
>>                    Latitude,
>>                    Longitude,
>>                    geography::Point(Latitude,Longitude,4326) AS geoPoint
>>          FROM      result
>>        ) geoData
>>WHERE   @area.STIntersects(geoData.geoPoint) = 1 ;

>
>I see that this one uses the meters approach. I like that. Also, what does the 4326 stand for?
>
>I tested that and it works fine. Thanks

It is a datum SRID (spatial reference ID). Don't bother with it if you are not into GIS yourself (earth's coordinate system uses a series of different datums - reference systems. 4326 is the SRID of most common WGS 84 datum and also SQL server's default).
Cetin