with tb(ID) as
(
SELECT 'A1-2-3' UNION ALL
SELECT 'A10-5-6' union all
select 'A2-2-2'
)
, tb2 as
(
select
SUBSTRING(id,1,1) as row1
, substring(id,2,charindex('-',id)-2) as row2
, Replace(substring(id,charindex('-',id)+1,2),'-','') as row3
, Replace(RIGHT(id,2),'-', '') as row4
from tb
)
select row1 + RIGHT('0'+row2,2) + '-' + RIGHT('0'+row3,2) + '-' + RIGHT('0'+row4,2)
from tb2