SQL to Parse an address in to street number, street name, and street type

I have a string field with the following:  "123 Main Street"

I need to parse the field in to 3 different fields by street number, street name, and street type.

How is the best way to achieve this?