
If I have geometry table with a geometry column named GEOMETRY that is a point geometry type. I need to know how I can write a query that will give me all of the points within a specific radius. Any ideas? I keep trying to use the IsWithinDistanceQuery
function, but I get a myriad of errors. My syntax is:
SELECT q.*
FROM ST.IsWithinDistanceQuery#dbo#ZIPLatLon#GEOMETRY('GEOMETRY', 100) AS q

