Object type: User defined function

Scalar function used by the Sales.Customer table to help set the account number.

Syntax

dbo.ufnLeadingZeros ( Value )

Parameters 

Variable	Data Type	Required	Description
Value	int	Yes	Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer.

Properties 

Output data type	Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
varchar(8)	No	No	No	No	No

Applies to

Functions | Scalar

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation