hi all ,
I have one problem

that is I would like to take only number from String like : 80EB or 80S
from this Strings I want to take only 80

so IS there any method in the SQL ??
if yes please send to me as soon as possible

thanks
byee