How to split this lattiude in sql server

Hi Adhikar,

 

SEE WHAT YOU WANT, SAMPLE:

select fld1 + fld2 + fld3 as result FROM (
select substring('12°20''''30"',1,2) + ' DEG ' as fld1,
substring('12°20''''30"',4,2) + ' MIN ' as fld2,
substring('12°20''''30"',8,2) + ' SEC' as fld3) t;

RESULT: '12 DEG 20 MIN 30 SEC' 

 

 

select fld1 + fld2 + fld3 as result FROM (
select substring(YOURFIELD,1,2) + ' DEG ' as fld1,
substring(YOURFIELD,4,2) + ' MIN ' as fld2,
substring(YOURFIELD,8,2) + ' SEC' as fld3) t 

 

RUN THIS SELECT TO GET SAMPLE:
select substring('12°20''''30"',1,3) as fld1,
substring('12°20''''30"',4,3) as fld2,

substring('12°20''''30"',8,3) as fld3;

 

RUN THIS WITH YOUR FIELD OR DATA:
select substring(YOURFIELD,1,3) as fld1,
substring(YOURFIELD,4,3) as fld2,
substring(YOURFIELD,8,3) as fld3;

 

Best,

 

Jeff