[mssql] Oracle의 Lpad => mssql용 으로변환

 

 

-- select  unilite.fnLpad(2,4,'0')    결과 0002

 

IF OBJECT_ID('unilite.lpad') IS NOT NULL
   DROP FUNCTION unilite.fnLpad
GO

CREATE FUNCTION unilite.fnLpad
 (
  @mstr AS varchar(8000),
  @nofchars AS int,
  @fillchar AS varchar(8000)=' '
 )
RETURNS varchar(200)
AS
BEGIN
 RETURN
  CASE
   WHEN LEN(@mstr) >= @nofchars THEN LEFT(@mstr, @nofchars)
   ELSE
    LEFT(REPLICATE(@fillchar, @nofchars), @nofchars-LEN(@mstr)) + @mstr
  END
END
GO