How to return only text matching query criteria

[postman]

Is there a way to only return the text from a field that matches the criteria?

For example, if the criteria for the query is "Like *########*" (any 8-digit numbers at any position in the field), and there is a record where the field contains this text: "for customer #99999999 calling about an issue", can you return just the "99999999" part in the query?

Thanks.

[ChipR]

It may be possible, depending on your situation. You could create a function which returns only the numeric parts of a string and call it in your query for each record. Be careful, since too much of this could slow the query significantly.