Subject Extract email addresses from blob via LIST and SIMILAR TO
Author Roberto Carlos
In Firebird 2.5, I have a blob sub_type text field that have very large text containing many email addresses.
For example:
'aaa bbb ccc. ddd eee fff ggg@..., hhh iii jjj@.... Kkk lll mmm@...; nnn'

How could I use LIST and SIMILAR TO to extract many email addresses form this blob field?

Thanks to all kind of help.