Well, essentially no.

It does store the lat,long and you can read them later.

But it actually creates the logic behind those coordinates allowing the server to compare and use them...

Here is what I used, since I don't have a Zip relationship, and the current lat/lon is alreayd known to the script.

distcheck = "100"

lat = "39.023445"

lon = "-113.23444"

sql = "...

sql1 = "SELECT coords.Lat, coords.Long FROM testing WHERE id=1"

lat2 = rs(0)

lon2 = rs(1)

sql2 = "SELECT * FROM testing WHERE id <> 1 AND coords.STDistance(geography::Point(" & lat2 & ", " &...

Thanks for your help, but those links where the ones I was trying to figure out. They are either zip code translations which completely throws me off, or are declaring...