declare @x int
set @x=1
select right('000'+cast(@x as varchar(10)),4) as resultor:declare @x varchar(10)
set @x='1'
select right('000'+@x,4) as result
set @x=1
select right('000'+cast(@x as varchar(10)),4) as resultor:declare @x varchar(10)
set @x='1'
select right('000'+@x,4) as result
set @x=1
select right('0000'+cast(@x as varchar(10)),4) or:declare @x varchar(10)
set @x='1'
select right('0000'+@x,4) as result
set @d = 100
set @i = len(@d)
set @n = case @i
when 1 then '000'+cast(@d as nvarchar)
when 2 then '00'+cast(@d as nvarchar)
when 3 then '0'+cast(@d as nvarchar)
else cast(@d as nvarchar)
end
select @n