To extract the last word in a string

Hi

I am using BODS 14.1.1.210

I would like to extract the last word in a string in BODS query. How can I achieve this when I don't know how many words are present in a space delimited string.

Example

Input Output

My name is Tim Tim

Complicated Complicated

there is a bird in the nest nest

Please let me know if there is a query function for this one.

Cheers!