| Subject | Re: [firebird-support] String function extract last word from a string |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2016-04-12T15:07:35Z |
12.04.2016 17:00, 'Checkmail' check_mail@... [firebird-support] wrote:
--
WBR, SD.
> is it possible to extract the last complete word from a string until the last blank? ForRIGHT(string, POSITION(' ' in REVERSE(string)))
> example “I would like to eat a bacon” In this case I would like to have the “bacon” as result.
--
WBR, SD.