How to convert int to char with leadind zeros ?
Posted
by Bitnius
on Stack Overflow
See other posts from Stack Overflow
or by Bitnius
Published on 2010-03-07T17:32:13Z
Indexed on
2010/03/08
0:12 UTC
Read the original article
Hit count: 590
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
© Stack Overflow or respective owner
