CREATE FUNCTION fn_MyPadding (
	@Text			AS VARCHAR(500),
	@Char			AS CHAR(1),
	@HowMany		AS INT,
	@LeftRight	AS CHAR(1) = 'L')
RETURNS VARCHAR(500) AS 
BEGIN
	IF @Text IS NULL
		SET @Text = @Char
	
	DECLARE @Count	SMALLINT
	SET @Count = LEN(@Text)
	
	IF @LeftRight	=	'L'
		SET @Text	=	REVERSE(@Text)
	
	SET @Text	=	@Text + REPLICATE(@Char, @HowMany - @Count)
	
	IF @LeftRight	=	'L'
		SET @Text	=	REVERSE(@Text)
	
	RETURN (@Text)
END

-- =============================================
-- Author:		Aaron N. Cutshall
-- Create date: 21-Apr-2008
-- Description:	Pad string with given character for length given
-- =============================================
ALTER FUNCTION fn_PadStr(
	@OrigStr varchar(512),
	@PadChar char(1) = ' ',
	@Length int,
	@Orientation char(1) = 'L')
RETURNS varchar(512)
AS
BEGIN
	RETURN CASE WHEN @Orientation = 'R' THEN @OrigStr ELSE '' END +
				REPLICATE(@PadChar, @Length - LEN(@OrigStr)) +
				CASE WHEN @Orientation = 'L' THEN @OrigStr ELSE '' END
END

/*
Example:						Result:
SELECT dbo.fn_Padding('1', '0', 3, 'L')			001
SELECT dbo.fn_Padding('15', '0', 3, 'L')			015
SELECT dbo.fn_Padding('ABC', '*', 10, 'R')		ABC*******
SELECT dbo.fn_Padding('ABC', '_°', 10, 'R')		ABC_°_°_°_
SELECT dbo.fn_Padding('ABC', '_°', 10, 'L')		°_°_°_°ABC
*/

CREATE FUNCTION dbo.fn_Padding 
(
	@Text			VARCHAR(8000), 
	@PaddingChars	VARCHAR(20), 
	@StringLength	INT, 
	@Direction		CHAR(1) = 'L'
)
RETURNS VARCHAR(8000) 
AS 
 BEGIN 
	DECLARE @PaddingString	VARCHAR(8000)

	-- Build string to use for padding
	SET @PaddingString = REPLICATE(@PaddingChars, (@StringLength / LEN(@PaddingChars)) + 1)

	-- Left padding
	IF (@Direction = 'L') 
		SET @Text = RIGHT(@PaddingString + COALESCE(@Text, ''), @StringLength)

	-- Right padding
	IF (@Direction = 'R') 
		SET @Text = LEFT(COALESCE(@Text, '') + @PaddingString, @StringLength)

	RETURN @Text
 END

/* *************************************************************
* Author:  	Mike Garrison
* Create Date:  04-21-08
* Description:  Pad a string to a given length to either side
**************************************************************** */

ALTER FUNCTION dbo.udf_PadString (
	@Text VARCHAR(500) = '', 
	@Char VARCHAR(50), 
	@Length INT,
	@Orientation CHAR(1) = 'L')

RETURNS VARCHAR(500) 
AS 
BEGIN
    IF @Length < LEN (@Text)
        SET @Length = LEN(@Text)
    RETURN CASE WHEN @Text IS NULL THEN REPLICATE(@char, @length)
		WHEN @Orientation = 'L' THEN RIGHT(REPLICATE(@char, @length) + @text, @Length)
		WHEN @Orientation = 'R' THEN LEFT(@text + REPLICATE(@char, @length) , @Length)
		ELSE ''
	   END
END