Your query is good only for number who has only alpha in the end e.a:

25/b --> 25 good
115b5 --> 1155 not good but 115

in fact i just want the number before the 1st character non numeric

thx for you reply