Thankx to By Joshua A. WalkerTESTING: 
SELECT dbo.DBA_fnAddLeadingZeros(2457,6)
Result: ‘002457”
***************************************************************************/
CREATE FUNCTION [dbo].[DBA_fnAddLeadingZeros](@Int INT, @TotalLength INT)
RETURNS VARCHAR(2000)
AS
BEGIN
     DECLARE @Return VARCHAR(2000)

/************************************************************************

        –IF @TotalLength > 100 SELECT @TotalLength = 100
      SELECT @Return = replicate(‘0′,@TotalLength) + CAST(@Int AS VARCHAR)
      RETURN RIGHT(@Return,@TotalLength)

Happy Programming !!!!