I have a column called FIRST_NAME (that currently contains full name). I have another column called LAST_NAME (last name). I need to alter the FIRST_NAME column so that it contains the proper first name. The last name is to go to the LAST_NAME column. For example:
If FIRST_NAME contains 'NENO S ASBERRY' then it should contain only NENO. 'S ASBERRY' should go to the LAST_NAME column.
I want it changed to this:
This query will be there in procedure:
Concatenated peoples' names are painfully fickle as discussed here
I'd also add that you probably don't want to overwrite your source data (currently in the column called FIRST_NAME) because you have nothing to refer back to later on in you suspect a problem. Having said all of that, this will probably do what you want it to do: