udfPadLeft()

This object is referenced by various other objects in this blog.

USE Admin

IF OBJECT_ID('dbo.udfPadLeft') Is Not Null

      DROP FUNCTION dbo.udfPadLeft

GO

CREATE FUNCTION dbo.udfPadLeft(

      @In varchar(100),

      @Width int,

      @PadChar varchar(1)

      )

RETURNS varchar(100)

AS

/*    DATE        AUTHOR            REMARKS

      7/23/13           PPaiva            Initial creation.

     

      DESCRIPTION

            Pads @In with @PadChar so that the length of the returned

            value is @Width.  If the length of @In is greater than @Width

            then @In is returned. 

      USAGE

            SELECT dbo.udfPadLeft('7', '3', '0')

*/

BEGIN

      DECLARE @Out varchar(100),

                  @LenIn int

      SET @LenIn = Len(@In)

     

      IF @Width - @LenIn < 0

            SET @Out = @In

      ELSE

            SET @Out = REPLICATE(@PadChar, @Width - @LenIn) + @In

      RETURN @Out

END