Don't do this in SQL: while it is possible, it's very messy:
SELECT REPLACE(REPLACE(REPLACE(ColumnNameContainingLattitude, N'°', N' DEG ' ), N'''', ' MIN '), N'"', ' SEC') FROM MyTable
Either do it in your presentation software, or better, store it as three integer values LatDegrees, LatMinutes, and LatSeconds instead of as a single string then use those to generate your string.