<< Null FName FName LName FName1, FName2 FName1, FName2, FName3 So, what would be the best way to break it apart? Should I use a temporary table? I thought of using SSUB, but that wouldn't work for the ones that had a First and Last name in the field with just a space in between. >>
This looks fairly straightforward. I would run a cursor loop through the table, and use SSUB to get out each "name". Then, I'd use SSUB _again_ on the "name" to see if there's a first and last name in it. (The second SSUB is with a negative index to split on a space character). Then, with either a first name, or a first and second name, update the new fields. The only time you'll need to pay special attention is when that second SSUB comes back with more than two terms -- meaning either you've found a name with three or more parts or else that someone left out the comma between two consecutive names. -- Larry
