extract a part of value from column values

Hi experts,

I have a column 'Tracking code' contains the data like 'AE000030ROWLB',

is it possible to extract 'AE000030' this alone from the tracking code column?

Could you please give me a solution for this?

select substr(column_name,1,8) from table_name