Bong's

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

카테고리 없음 2020. 3. 29. 02:55