An Address consists officially, per the USPS, of five lines. It sounds like one of those lines is taken up with the distinct fields City, State and Zip. One approach would be to populate the other lines by taking SUBSTRINGs of your Address field based on the location of each Carriage Return. This gets ugly quickly but would be conceptually straightforward. An alternative approach would be to use a splitter function, such as here http://www.sqlservercentral.com/articles/Tally+Table/72993/, using Carriage Return as the delimiter and then Pivot the data to fill your four fields.