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.