Stakoverflow - I have a column batch code having any combination of alphabet and number, Sql Server

Language: Layout:

declare @T as table
(
    id int identity(1,1),
    barcode varchar(10)
)

insert into @T values
('101'), ('102'), ('102.aaa'), ('a103'), ('b101'), ('a104')

select  top 1 barcode
from @T
order by cast( 
            replace(barcode,    
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    replace(
                                        replace(
                                            replace(
                                                replace(
                                                    replace(barcode, '0', '')
                                                , '1', '')
                                            , '2', '')
                                        , '3', '')
                                    , '4', '')
                                , '5', '')
                            , '6', '')
                        , '7', '')
                    , '8', '')
                , '9', '')
            , '') 
         as int) desc

View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 6, absolute service time: 0,17 sec

Stakoverflow - I have a column batch code having any combination of al...