Type:
Scalar function
This function answers the question whether a given string representing an integer is modulus 10 check compliant (ie. whether the last digit of its modulus 10 checksum i zero).
This is thus the check to use as part of validating the integrity of any modulus 10 encoded integer string such as a social security number or an OCR-number.
If the string to check is either null or if it contains any character that is not a digit then the function will return a value of null.
Return value: bit
Returns 1 if string is modulus 10 check compliant and 0 otherwise.
Parameters
@IntegerString
mandatory
varchar(8000)
The integer string for which to check for modulus 10 compliance.