Hi all, I would like to know if there is a function exists in oracle to perform the following. We have a free-form text field and we need to retrieve a numeric value from within, and the numeric can only be up to 2 character long. The numeric is ususally stored in this format '20 CAT'. Since this is a free-form text field, user can also input '20CAT' or 'XXX20CAT'. What function should I use to achieve what I need? Please help.