DECLARE @INPUTSTRING INT SET @INPUTSTRING = '000009'+1SELECT REPLICATE('0', 6 - LEN(@INPUTSTRING)) + CAST (@INPUTSTRING AS VARCHAR) AS FORMATTEDVALUE
Thanks, A2H My Blog
DECLARE @Num varchaR(10) = '000009'select right('000000'+ cast(@Num+1 as varchar), 6) as NextNum
NextNum 000010
Login to post response