select case len(cast(9 as varchar(4))) when 1 then '000' + cast(9 as varchar(4)) when 2 then '00' + cast(9 as varchar(4)) when 3 then '0' + cast(9 as varchar(4)) when 4 then cast(9 as varchar(4)) end
谢谢 楼上给我的提示: 我决定这样写 select right('0000'+cast(99 as varchar(4)),4)
when 1 then '000' + cast(9 as varchar(4))
when 2 then '00' + cast(9 as varchar(4))
when 3 then '0' + cast(9 as varchar(4))
when 4 then cast(9 as varchar(4)) end
我决定这样写
select right('0000'+cast(99 as varchar(4)),4)