I have a database that contains address 1 and address 2 data. In doing some data validation with USPS software, the Ste X/Floor/Bldg. information needs to be in the address 2 field. There are more than 3000 records that have the information combined.
How can programmatically strip the Ste X data from the address 1 field and put it into the address 2 field?