Convert a varchar to a number

[yahrika]

Hi all,

I've some problem i'd like with a query to have a numeric part
of a field that contains alpha-numeric

e.a
----

Streetnumber : 25/b ---> 25
115b5 --> 115
140/ --> 140



Thx in advance