I'm using SQL Server and WKT to deal with geographic data. What I'd like to do is have something like :
FROM point_table, polygon_table
where pt.point_table WITHIN ply.polygon_table
Here pt is WKT point. Ex :
and ply is WKT polygon Ex :
'POLYGON (( lon1 lat1 , lon2 lat2 , lon3 lat3 , lon4 lat4 ))'