I am have a column of gemetry type in my sql server 2008 database. I stored POINT data there IE( POINT(23.989899, 21.090909). I have a parameter page in which I allow users to put a range on the latitude and longitude. My question is, how can
I use those parameters in a where clause to limits the records that come back based upon what the user enters? I have seen examples for most geometric data types but nothing for POINTs. For example, if the user enters in a latitude of greater than 10.010101
and a longitude of 45.999999, I want to return all the records containing lats > 10.010101 and longs greater 45.999999.....
I have tried several solutions with nothing working so far...
View Complete Post