| Subject | Re: AW: [firebird-support] string difficulty |
|---|---|
| Author | Virna Constantin |
| Post date | 2015-12-07T10:32:10Z |
select replace('ABC*DEFG********01','**','') from RDB$DATABASE
On Monday, December 7, 2015 12:26 PM, "Virna Constantin costel_61@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
sorry, wrong response :(
On Monday, December 7, 2015 12:22 PM, "Virna Constantin costel_61@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
a quick answer :
m_char='**'On Monday, December 7, 2015 12:12 PM, "'checkmail' check_mail@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
But If the ID is ABC*DEFG, I get ABC*DEFG********01 and in this case only all * from right should be deleted.I have create this, is there a simpler way?