<div>
what about this:<br />
<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76195" rel="ugc">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76195</a>
</div>


what about this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76195 [http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76195]

<div>
@arcee123 it works!. Thanks for posting the full steps on how to run as well.
</div>


@arcee123 it works!. Thanks for posting the full steps on how to run as well.

<div>
<div class="content wysiwyg-content">
This is a challenging question, so I can understand if I get no responses but I thought I would give a shot. &nbsp;Thanks for any help you can give.<br />
I have a 15 Digit customer number that I need to calculate a check digit for that value.<br />
In order to come up with the check digit I use Excel (formula is below). &nbsp;<br />
This formula is based on something called the Luhn Algorithm (I think that is the correct spelling). <br />
The 15 digit customer number is stored in a SQL Server 2000 Database. &nbsp;<br />
I would like to be able to get this calculation using a T-SQL Function rather than <br />
Excel. &nbsp;Does anyone know how is can do this with T-SQL on a SQL Server 2000 database<br />
<br />
Excel Formula that will give me a check digit from a 15 digit number<br />
=MOD(SUMPRODUCT(-MID(TEXT(<wbr />MID(A2,ROW<wbr />(INDIRECT(<wbr />&quot;1:&quot;&amp;LEN(A<wbr />2))),1)*(M<wbr />OD(ROW(IND<wbr />IRECT(&quot;1:&quot;<wbr />&amp;LEN(A2)))<wbr />+LEN(A2)+1<wbr />,2)+1),&quot;00<wbr />&quot;),{1,2},1<wbr />)),10)
</div>
</div>


This is a challenging question, so I can understand if I get no responses but I thought I would give a shot.  Thanks for any help you can give.
I have a 15 Digit customer number that I need to calculate a check digit for that value.
In order to come up with the check digit I use Excel (formula is below).  
This formula is based on something called the Luhn Algorithm (I think that is the correct spelling). 
The 15 digit customer number is stored in a SQL Server 2000 Database.  
I would like to be able to get this calculation using a T-SQL Function rather than 
Excel.  Does anyone know how is can do this with T-SQL on a SQL Server 2000 database

Excel Formula that will give me a check digit from a 15 digit number
=MOD(SUMPRODUCT(-MID(TEXT(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)*(MOD(ROW(INDIRECT("1:"&LEN(A2)))+LEN(A2)+1,2)+1),"00"),{1,2},1)),10)

T-SQL (advanced custom function)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.