sunitabeck may have a better idea once we know the type of your data. The below would work assuming the data is consistent and contains the ° ' " symbols in that order but will not warn you if it does not. If your data type is some kind of (n)varchar you might look to converting it to normalized data, Google Maps has allot of free toolsSelect(Abs(SubString(Lat, 0, CharIndex('°', Lat)))+ (SubString(Lat, CharIndex('°', Lat) + 1, CharIndex(Char(39), Lat) - CharIndex('°', Lat) - 1) / 60.0)+ (SubString(Lat, CharIndex(Char(39), Lat) + 1, CharIndex('"', Lat) - CharIndex(Char(39), Lat) - 1) / 3600.0))* Sign(SubString(Lat, 0, CharIndex('°', Lat))), (Abs(SubString(Lng, 0, CharIndex('°', Lng)))+ (SubString(Lng, CharIndex('°', Lng) + 1, CharIndex(Char(39), Lng) - CharIndex('°', Lng) - 1) / 60.0)+ (SubString(Lng, CharIndex(Char(39), Lng) + 1, CharIndex('"', Lng) - CharIndex(Char(39), Lng) - 1) / 3600.0))* Sign(SubString(Lng, 0, CharIndex('°', Lng)))From @Table
PS, is that your house? Big front yard...Robert '); drop table students;-- ?