AddZeroDigit

How to add Zero to an integer value from left (like 9 to 009)

Create function :

CREATE FUNCTION dbo.AddZeroDigit(@Value AS int)
RETURNS varchar(3)

BEGIN

DECLARE @Result varchar(3)

SET @Result = RIGHT('000'+CAST(@Value AS varchar(3)),3)

RETURN @ResultEND

Test :

SELECT dbo.AddZeroDigit(9) AS Result

Result :