[MSSQL] 왼쪽 특정문자 채우기

1. FUNCTION 생성

CREATE FUNCTION dbo.FN_LEFT

(

    @INPUT NVARCHAR(1000)

    , @COUNT AS INT

    , @FILLCHAR AS CHAR(1) = ' '

)

RETURNS NVARCHAR(200)

AS

BEGIN

RETURN

    CASE

        WHEN LEN(@INPUT) >= @COUNT

        THEN LEFT(@INPUT, @COUNT)

    ELSE

        LEFT(REPLICATE(@FILLCHAR, @COUNT), @COUNT-LEN(@INPUT)) + @INPUT 

    END

END

2. 예시

SELECT dbo.FN_LEFT( '7777', 10, '0' ) AS SAMPLE

 

> 결과

0000007777