How to extract text patterns from string value?

Hi all,   I have a database with a various length description column, which contains a product ID somewhere in it (even at the beginning, middle or end of the description). These product IDs follow...