| Add extra zero on left hand side of int value in SQL through query?
Below is the query to add extra zero or any character in the field of any column
declare @FieldVal as int
set @FieldVal=3;
select cast(Format(@FieldVal,'0000') as varchar(4))
Output is :- 0003
or
SELECT FORMAT(Col_ID, '000000')
FROM dbo.Table_Name WHERE ID=1
| | |