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