I'm looking SQL command for the MOD10 Validation on 23rd numeric number. We have all 22 numbers are numeric from that I need to get the 23rd number as MOD10 check. Please feel free to share with me if any of you have the logic.
asked Jun 28, 2011 at 02:31 PM in Default
Here it goes:
Just restate it as you see fit. The number provided in the sample results in the valid combination compliant with CC10 a.k.a. MOD10 algorithm.
In your case, you probably want to consider passing the 22 digits and one more zero on the right of it to the guts of the select statement, which returns the sum. Take 10 - (mod 10 of it) and you will get the value of the rightmost digit as it should be in place of zero.