I came across the same situation and I found the working solution for it.

Here is the link:

http://www.ittutorials.in/source/sql/sql-function-to-extract-only-numbers-from-string.aspx