RPAD 구현
CREATE FUNCTION F_RPAD(@TEXT VARCHAR(200),@MAX_COUNT INT,@PAD_CHAR CHAR(1))RETURNS VARCHAR(200)ASBEGINDECLARE @RTNVAL VARCHAR(200)SELECT @RTNVAL = RIGHT(REPLICATE(@PAD_CHAR, @MAX_COUNT) + @TEXT , @MAX_COUNT)RETURN @RTNVALEND
DataBase/SQL Server
2014. 9. 18. 13:38