I'm fairly experienced when using SQL but new to using the geometry features. I suspect the problem I have is fairly easy to solve but I've yet to find a solution for it.
I have a db containing a number of boxed geographical regions that are represented by 4 lat/lon points
I also have a single lat/lon point from which I want to do a radius search. When I do the search I want to select any of the boxed geographical regions that fall either entirely or partially within the radius search.
As the moment the lat/lon fields are stored in a decimal filed in sql but I can change them over to the geography datatype if that make solving the problem easier