Thanks to all the comments, you got me moving in the right directions. I finally wound up with this code : round(cast(cast(cast(substring(cast(cast(inv.latitude as int) as varchar),1,2) as int) as numeric) + cast(cast(substring(cast(cast(inv.latitude as int) as varchar),3,2) as int) as numeric)/60 + cast(cast(substring(cast(cast(inv.latitude as int) as varchar),5,4) as int) as numeric)/100/3600 as varchar),5) as "Latitude"

Yes, its bad. But its verified working and unless I can get the DBA to change how he captures/stores data... it is what it is...