title: Finding a geography point within a range of another - SQL Server
body: <p>I have a table in SQL Server that has geography datatype column in it. I want to query this table to find rows that fall near (within a range) of another given geography point. Does anyone have any ideas as to the best way to do this?
  I have 2 options of where to do this type of query. I can write it on the sql server as a stored proc or I can do it in c# code as I am using the Entity Framework for data access.</p>
  
  <p>I would have a query that has a range (eg 100m) and a geography point passed in to it.
  The pseudo code would be something like this...</p>
  
  <p>select rows 
  where rows.geo within range of given geography point</p>
  
  <p>I'm having a bit of trouble finding examples of geography queries in SQL Server on the web.</p>
  
  <p>Any help would be appreciated.</p>