<div>
The string I entered in Google Maps was 40 45.2576, -73 52.8029
</div>


The string I entered in Google Maps was 40 45.2576, -73 52.8029

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


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.

GPS coordinates in SQL to google map

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.

GIS/GPS Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.