CREATE PROCEDURE sp_LPAD @RefString char(10) OUTPUT, @PadChar char(1) = '0' AS DECLARE @stringLen int, @newstring char(10) SET @stringLen = LEN(@RefString) SET @newstring = REPLICATE(@PadChar, DATALENGTH(@RefString) - @stringLen) + @RefString SET @RefString = @newstring