Properties

Owner:	dbo
Type:	SQL scalar function
Encrypted:
Creation Date:	04/26/2006
Modification Date:	04/26/2006
Description:	Scalar function used by the Sales.Customer table to help set the account number.

Creation options

QUOTED_IDENTIFIER:
ANSI_NULLS:

Parameters

	Name	Direction	DataType	Length	Default	Description
	@RETURN_VALUE	RETURN	varchar	8
	@Value	INPUT	int	4		Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer.

Total: 2 parameter(s)

Objects that depend on [dbo].[ufnLeadingZeros]

	Object Name	Owner	Object Type	Dep Level
	Customer	Sales	Table	1
	CustomerAddress	Sales	Table	2
	Individual	Sales	Table	2
	SalesOrderHeader	Sales	Table	2
	Store	Sales	Table	2
	vIndividualCustomer	Sales	View	3
	vIndividualDemographics	Sales	View	3
	vSalesPersonSalesByFiscalYears	Sales	View	3
	SalesOrderDetail	Sales	Table	3
	SalesOrderHeaderSalesReason	Sales	Table	3
	StoreContact	Sales	Table	3
	iStore	Sales	Trigger	3
	iuIndividual	Sales	Trigger	3
	uSalesOrderHeader	Sales	Trigger	3
	ufnGetContactInformation	dbo	Function	4
	vStoreWithDemographics	Sales	View	4
	iduSalesOrderDetail	Sales	Trigger	4

Total: 17 object(s)

SQL

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION [dbo].[ufnLeadingZeros](
    @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
SET QUOTED_IDENTIFIER OFF
GO

GO
SET ANSI_NULLS OFF
GO

See Also

List of functions