Hi all,
I have a table containing coordinates, the problem is that the dot (.) is missing.
The query should add a . after the 2nd character in the latitude column and after the 1st character in the longitude.
Input:
Latitude Longitude 529645 604347
Result:
Latitude Longitude 52.9645 6.04347
Many thanks,
Ed