Hallo Max,
es geht auch so:
with daten (text) as
(select 'Hugo 05' from sysibm/sysdummy1
union all
select 'HUGO/01' from sysibm/sysdummy1
union all
select 'HuGo 2010' from sysibm/sysdummy1
union all
select 'hugo 07' from sysibm/sysdummy1
union all
select '07 / Hugo' from sysibm/sysdummy1),
conv (text, nbr) as
(select text,
trim(translate(xor(text,
translate(text,x'00000000000000000000',
'0123456789')),
' ', x'00'))
from daten)
select * from conv

==>

TEXT NBR
Hugo 05 05
HUGO/01 01
HuGo 2010 2010
hugo 07 07
07 / Hugo 07