J
JohS
I've a table with a field storing Fullname and tries to split that field
into FirstName and LastName.
To pick out Firstname goes well with this:
Left(Fullname,InStr(FullName," ")-1) AS FirstName¨
But how can I pick out the last word (I've decided to go for that as
LastName and will adjust the ones witch fails manually) as LastName?
I have names like these:
Nils Ole Astrup Hansen
Svein Henning Aukland
Anne Karin Bache
Geir Markhusen
Lars Christensen
Thanks,
JohS
into FirstName and LastName.
To pick out Firstname goes well with this:
Left(Fullname,InStr(FullName," ")-1) AS FirstName¨
But how can I pick out the last word (I've decided to go for that as
LastName and will adjust the ones witch fails manually) as LastName?
I have names like these:
Nils Ole Astrup Hansen
Svein Henning Aukland
Anne Karin Bache
Geir Markhusen
Lars Christensen
Thanks,
JohS