Parsing out just the last name

[sawilliams]

Hello:

I am trying to query out just the last name from a "greeting" field. For the entry "Mr. Carlos A. Gibson", I just want "Gibson". Any assistance would be greatly appreciated.

SAW

 

[Remou]

A very rough way to get the last 'word' is to split at the last space. There is no guarantee that this is the last name as Mc Gregor and De La Fontaine will not come across:

[tt]Mid(SFName,InstrRev(SFName," ")+1)[/tt]