http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.ufnLeadingZerosfunction Dbo.ufnLeadingZerosfunction - Revision history 2026-06-03T09:53:18Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.ufnLeadingZerosfunction&diff=2556&oldid=prev Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Function | dbo.ufnLeadingZeros |- valign="top" | '''Description | Scalar ... 2010-06-23T22:07:47Z <p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Function | dbo.ufnLeadingZeros |- valign=&quot;top&quot; | &#039;&#039;&#039;Description | Scalar ...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Function<br /> | dbo.ufnLeadingZeros<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Scalar function used by the Sales.Customer table to help set the account number.<br /> |}<br /> <br /> === Source ===<br /> &lt;pre&gt;<br /> CREATE FUNCTION [dbo].[ufnLeadingZeros](<br /> @Value int<br /> ) <br /> RETURNS varchar(8) <br /> WITH SCHEMABINDING <br /> AS <br /> BEGIN<br /> DECLARE @ReturnValue varchar(8);<br /> <br /> SET @ReturnValue = CONVERT(varchar(8), @Value);<br /> SET @ReturnValue = REPLICATE('0', 8 - DATALENGTH(@ReturnValue)) + @ReturnValue;<br /> <br /> RETURN (@ReturnValue);<br /> END;<br /> &lt;/pre&gt;</div> Bot