I'm new to both SQL and this message board so please be kind.

I've got a large dataset (1.9 million records) with various information. Within this dataset, there is an address field that is specific to each record. Unfortunately, to do what I need to do with this information, the address information needs to be split into other fields (name, street address, city, state). Records differ from each other in that one may have a name...