in my country first name is just that…FIRST name. a first name can’t have 2 names… Guess in english that’s possible. if you can’t control the source data (which is the n.1 best option and should be the way to go), the solution is a little more complex then. you need a table of execptions, word counting and thats all. if you have more than 2 words in a line you need to compare the middle names with the execption table from there you can decide where to cut ;), still i believe this is not the way to go…the Alan solution or mine trying to change the source would be the correct solution.
