I have database that is full of demographic information including addresses. I need to extract just address information and remove any references to apartment and suite numbers and floors and the like. This is because I have table that full of latitude and longitude records that are base solely on the address portion of the data. Does anyone have any helpful tips on how to accomplish this? My thought right now is to scan what is in there right now and use the replace command to change them to blanks but I was wondering if there is a better way.