SQL Server: 自定义函数 Fun_PadLeft

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fun_PadLeft]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
	DROP FUNCTION [dbo].[Fun_PadLeft]
go
-- =============================================
-- Author:		yenange
-- Create date: 2015-01-04
-- Description:	右对齐的字符，在左边用指定的字符填充以达到指定的总长度
-- =============================================
CREATE FUNCTION dbo.[Fun_PadLeft] 
(
	@num varchar(16),			--原始字符
	@paddingChar char(1),		<span style="white-space:pre">	</span>--填充字符
	@totalWidth int				--结果字符串中的字符数
)
RETURNS varchar(16)
AS
BEGIN
	declare @curStr varchar(16)
	select @curStr = isnull(replicate(@paddingChar,@totalWidth - len(isnull(@num ,0))), '') + @num
	return @curStr
END
GO