RPAD 구현

CREATE FUNCTION F_RPAD

(

@TEXT VARCHAR(200),

@MAX_COUNT INT,

@PAD_CHAR CHAR(1)

)

RETURNS VARCHAR(200)

AS

BEGIN

DECLARE @RTNVAL VARCHAR(200)

SELECT @RTNVAL = RIGHT(REPLICATE(@PAD_CHAR, @MAX_COUNT) + @TEXT , @MAX_COUNT)

RETURN @RTNVAL

END