Table Function Query

Topics: Developer Forum, User Forum
Jan 17, 2008 at 1:40 AM
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