How to convert int to char with leadind zeros ?
- by Bitnius
I need to convert int data table field to char leading zeros
example:
1 convert to '001'
867 convert to '000867'
thx.
( This is my response 4 Hours later ... )
I tested this T-SQL Script and work fine for me !
DECLARE @number1 INT, @number2 INT
SET @number1 = 1
SET @number2 = 867
SELECT RIGHT('000' + CAST(@number1 AS NVARCHAR(3)), 3 ) AS NUMBER_CONVERTED
SELECT RIGHT('000000' + CAST(@number2 AS NVARCHAR(6)), 6 ) AS NUMBER_CONVERTED
