declare @x intselect @x=32 select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) rr --------- 32000 select @x=355 select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) rr -------- 35500
declare @x int select @x=32 select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) r r 32000select @x=355 select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) r r 35500
declare @a varchar(5); set @a='00000'; declare @test int; set @test=3; select left(@a,5-len(CAST (@test as VARCHAR )))+CAST (@test as VARCHAR )
declare @x intselect @x=32
select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) rr
---------
32000
select @x=355
select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) rr
--------
35500
select @x=32
select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) r
r
32000select @x=355
select cast(@x as varchar(5))+replicate('0',5-len(cast(@x as varchar(5)))) r
r
35500
declare @a varchar(5);
set @a='00000';
declare @test int;
set @test=3;
select left(@a,5-len(CAST (@test as VARCHAR )))+CAST (@test as VARCHAR )