Subject Re: [firebird-support] String function extract last word from a string
Author Dimitry Sibiryakov
12.04.2016 17:00, 'Checkmail' check_mail@... [firebird-support] wrote:
> is it possible to extract the last complete word from a string until the last blank? For
> example “I would like to eat a bacon” In this case I would like to have the “bacon” as result.

RIGHT(string, POSITION(' ' in REVERSE(string)))