jjc_Mtl

Usually, it's a good idea to make a first selection like this [CODE] SELECT * FROM POI WHERE ABS(rowLat - pLat)< 1 AND ABS(rowLong - pLong)<1 [/CODE] and apply the Distance function only on the small selection. < 1 means difference must be lower than 1 degree; you must adjust …

If you need a graphic user interface (to display maps) there is also MapInfo; If you only want to store geographical data and make calculation (distance between points, Point in polygon, adjacence of areas, and so on) Oracle Spatial is great.

Latitudes and longitude MUST be Double or Float jjc

Hi gurund, since you have 2 tables, I suppose you want to check if country_id exists; you open a connection : and test if country_id exists in [Country] [CODE] dim queryCmd as OleDbCommand Dim queryStrName, queryStr as String Dim noCountry as Integer Dim conn as new System.Data.OleDB.OleDbConnection(...) queryStrName = "SELECT …