USE [Test]

 GO

 SET ANSI_NULLS ON

 GO

 SET QUOTED_IDENTIFIER ON

 GO

 --@column 表示字段或者常量，@paddingChar  表示 补位字符， @len  补位数量， @returnStr

 create function [dbo].[PadLeft](@column varchar(16),@paddingChar char(1),@len int)

 returns varchar(16) as

     begin

         declare @returnStr varchar(16)

         select @returnStr = isnull(replicate(@paddingChar,@len - len(isnull(@column ,0))), '') + @column

         return @returnStr

     end