Another technique I've seen to remove alpha characters;

translate(val,translate(val, '1234567890',''),'')

where val is the column containing the data.

So,

select max(translate(val,translate(val, '1234567890',''),'')) as MAX_ID
from table

Ta,
Trent