Getting only Numeric Value

Question

Dear Frnds,
I am having a field which contains string(characters) and numeric value
example:-"aamir12000".
i just want to get the number not any text from it without using Substring().

please help in my query.


Thanks & Regards,
Aamir