Can you post the results of these queries? Replace the reds with the appropriate column and table names. Also, for at least one row of the result of the second query, post the covnerted result that you want to see.

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 tools