Hi some times we have requirment to add the zero's before no like (00010,01234), to do this below script will help to generate the no.
declare @inputNumber varchar(16) = 100 BEGIN declare @length int declare @result varchar(128)
set
@result = ''
set
@length = 0 declare @appendZero varchar(4)
set
@appendZero = '0000'
set
@length = Len(
ltrim(
rtrim(@inputNumber)
)
) declare @i int
set
@i = 1 if(@length > 0) begin while(@i != 5) begin if(@length = @i)
set
@result = Substring(
@appendZero,
0,
(5 - @i)
)
set
@i = @i + 1 end end else
select
@result
set
@result = @result + @inputNumber
select
@result END GO