Is there any Vsql function to derive numeric value of text?

For eg; I have a values in column like 9, 30, sixty days, five months

I want to convert these sixty days to 60

and five months to 5

I have done this using case when for possible scenarios looking if there is any direct function I can make use of..

Thanks in Advance!!