FUNC_Pad.sql

-- ======================================================================================
-- Author:      Adam Nofsinger
-- Created:     2013-04-29
-- Description: Utility to return an integer number as a string, padded to X many chars
--      with zeros to the left of the number.  E.g. Pad(45, 5) = '00045'
-- ======================================================================================
CREATE FUNCTION [dbo].[Pad] (
    @num integer,
    @len integer = 3
)   RETURNS varchar(100)
BEGIN 

    DECLARE @str varchar(100);
    SET @str = CAST(@num AS varchar);

    IF @len <= 10
        SET @str = RIGHT('000000000'+ @str, @len);
    ELSE
        SET @str = REPLICATE('0', @len - LEN(@str)) + @str;
        
    RETURN @str;
END