Hi,
Firebird 3
can someone tell me how to work with substring similar?
SELECT substring('abc' similar 'a' escape '#') FROM RDB$DATABASE
raise an error "Invalid SIMILAR TO pattern"
SELECT substring('ab11c' similar '[0-9]+' escape '#') FROM RDB$DATABASE
raise an error "Invalid SIMILAR TO pattern"
what i am doing wrong?
how this pattern should looks like?
regards,
Karol Bieniaszewski
[firebird-support] substring similar - "Invalid SIMILAR TO pattern"
liviuslivius [email protected] [firebird-support] Mon, 03 Dec 2018 00:54:35 -0800
- [firebi... liviuslivius [email protected] [firebird-support]
- Re... Mark Rotteveel [email protected] [firebird-support]
- ... Karol Bieniaszewski [email protected] [firebird-support]
- ... Mark Rotteveel [email protected] [firebird-support]
- ... Karol Bieniaszewski [email protected] [firebird-support]
