| Subject | substring similar - "Invalid SIMILAR TO pattern" |
|---|---|
| Author | liviuslivius |
| Post date | 2018-12-03T07:46:30Z |
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