I have GPS longitudes and latitudes saved in SQL server, it has format of dddd.dddd and Hemisphere value.
How do I convert this in SQL on fly so that Google map accepts it.
For example, one has;
LastGPS_Latitude LastGPS_LatHemisphere LastGPS_Longitude
4045.2576 N 7352.8029
This coordinate is supposed to show somewhere in New York city or close.