문자열 채우기

CREATE FUNCTION [dbo].[PadString]

(@Seq varchar(16),
 @PadWith char(1),
 @PadLength int
 )

RETURNS varchar(16) AS
 
BEGIN

declare @curSeq varchar(16)
 
SELECT @curSeq = ISNULL(REPLICATE(@PadWith, @PadLength - len(ISNULL(@Seq ,0))), '') + @Seq

RETURN @curSeq
 
END