Extracting the last word in a string

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What is the best method of extracting the last word in a string?
Example Table/Field1:

Field1
There once was a time
The old man sat
Two peas in a pod
One bird in the hand

function to extract the last word:

FunResult
time
sat
pod
hand

If it were the first word it would be: mid(Field1,1,instr(1,field1,"
"))

Thanks for any suggestions!

RBollinger
.

Quantcast