Separate First Name and Last Name from a single column Name.

Question

I need to separate last name from a cloumn StdName which have firstname, lastname and middle name in some.

Answer 1

@Michelle: Somebody wasn't happy with your answer. 😮

I guess you can't win them all. I'm going to hit the +1 for that last comment you posted receiving a -1 for offering to help.

Answer 2

@David, somebody jealous with our new mod probably :-)

Answer 3

@Michelle, I saw many promoted you for that, well in that case, maybe it's just somebody who got a warning from report, I guess.

Cheers..

Answer 4

@Michelle, yeah, I meant that down voter, maybe got warning from your report, hence the down votes. Thanks for being helpful around the neighborhood anyway.

Answer 5

I actually tried it but could separate the middle names.