fnPaddLeadingZeros

/****** Object:  UserDefinedFunction [dbo].[fnPaddLeadingZeros]    Script Date: 03/30/2012 13:04:52 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnPaddLeadingZeros]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnPaddLeadingZeros]
GO


/****** Object:  UserDefinedFunction [dbo].[fnPaddLeadingZeros]    Script Date: 03/30/2012 13:04:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[fnPaddLeadingZeros](
@Value int
)
RETURNS varchar(8)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @ReturnValue varchar(8);
SET @ReturnValue = CONVERT(varchar(8), @Value);
SET @ReturnValue = REPLICATE('0', 8 - DATALENGTH(@ReturnValue)) + @ReturnValue;
RETURN (@ReturnValue);
END;

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Input parameter for the scalar function fnPaddLeadingZeros. Enter a valid integer.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'fnPaddLeadingZeros', @level2type=N'PARAMETER',@level2name=N'@Value'
GO