Hi.
How can I get all occurrences on a field of a string using regex
substring similar?
For example:
SELECT SUBSTRING('asds 12.34 asd .5 aaa 6. aaa 0.5 aaa 7.3 aaa .4 aaaa
8. aaa 3.7' SIMILAR '% "[+-]?[0-9]*([0-9].|.[0-9])?[0-9]*" %' ESCAPE '')
FROM RDB$DATABASE;
This examples catches only the first occurrence, how to get them all?
Thanks.
