<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<div><p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">Hi All,<o:p></o:p></span></b></p><p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666"><br></span></b></p>
<p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">I have a column 'geocode' in a table which has
attributes like 2329/4727 now I would like to convert these </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attributes </span></b><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">in another
column to 'lat' and 'long'. For example, 'Lat' column will have </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attribute '</span></b><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">23.29' and 'long' column will have </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attribute </span></b><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666"> '47.27'.</span></b></p>
<p class="MsoNormal" style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; "><b><font class="Apple-style-span" color="#666666" face="Verdana, sans-serif" size="2">Is there a way through which this can be
converted automatically by a query or so.<o:p></o:p></font></b></p><p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666"><br></span></b></p><p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">Looking fwd..</span></b></p>
<p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">Thanks<o:p></o:p></span></b></p>
<p class="MsoNormal" style="font-size: 10pt; font-family: Tahoma; margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; line-height: normal; "><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";color:#666666">YJ<o:p></o:p></span></b></p></div> </div></body>
</html>