<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="margin: 0px; font-family: Verdana; font-size: 12px; ">I got myself into quite a mess and I'm hoping somebody out there can help me. I've created a database that includes in the range of 150 million records so far and I need to make a change to it. I have lat lon fields stored as strings in separate columns. What I would like to do is to take these 2 columns and created geometry column that combines both fields. I don't think there's a global function that will allow me to do this, but is there a way for me to use string formatting to do this easily?</div><div style="margin: 0px; font-family: Verdana; font-size: 12px; "><br></div><div style="margin: 0px; font-family: Verdana; font-size: 12px; ">Regards, </div><div style="margin: 0px; font-family: Verdana; font-size: 12px; "> Shaun Langley</div></body></html>