左填充

declare @t table(id int identity(1,1),col varchar(10))insert into @t (col) select 'a'unionselect 'b'unionselect 'c'select * from @tselect REPLICATE('0',4-len(id))+cast(id as varchar),col from @t