1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| select case when substr(cast(tab.C1 as char(7)), 1, 1)='9'
then concat( '0', substr(cast(tab.C1 as char(5)), 2, length(trim(cast(tab.C1 as char(5))))-1) )
else concat(substr('0000', 1, 5-length(trim(cast(tab.C1 as char(5))))), tab.C1)
end as CX1
, tab.C2
from
(select 1234 as C1, 'TOTO' as C2
union all
select 91200 as C1, 'TITI' as C2
union all
select 90022 as C1, 'tata' as C2
union all
select 0060 as C1, 'zzzz' as C2
union all
select 7 as C1, 'AKJU' as C2
) tab
order by CX1 |
Partager