I have to import a table into the database that has a field called Borrower Name. Unfortunately the First name, MI and Last Name are all included in this field. What query can I run to separate this into 3 separate fields?
For Example as it currently stands
John E. Doe is in one field, I want them separated.
For Example as it currently stands
John E. Doe is in one field, I want them separated.